title: What is the proper date format for this value?
body: <p>I know how to use ParseExact which is passed a date as a string plus the date format as a string. I can't seem to figure out the proper format for my date and was hoping to get some help. </p>
  
  <p>First the code:</p>
  
  <pre><code>For Each row In qryDays
  
     Dim strFloweredDate As String = row.Field(Of String)("FloweredDate")
     MessageBox.Show(strFloweredDate)
     Dim FloweringDate As Date
     FloweringDate = Date.ParseExact(strFloweredDate, "M/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)
  
     ' Also tried the following formats
     ' Dim FloweringDate As Date
     ' FloweringDate = Date.ParseExact(strFloweredDate, "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture)
     ' Dim FloweringDate As Date
     ' FloweringDate = Date.ParseExact(strFloweredDate, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)
     ' Dim FloweringDate As Date
     ' FloweringDate = Date.ParseExact(strFloweredDate, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)
     ' Dim FloweringDate As DateTime
     ' FloweringDate = DateTime.ParseExact(strFloweredDate, "M/dd/yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture)
     ' Dim FloweringDate As DateTime
     ' FloweringDate = DateTime.ParseExact(strFloweredDate, "M/dd/yyyy h:mm:ss", System.Globalization.CultureInfo.InvariantCulture)
     ' ETC ETC ETC
  
  Next
  </code></pre>
  
  <p>Now two photos. One of the Messagebox results showing the date and the other is the error:</p>
  
  <p><img src="https://i.stack.imgur.com/IjlCI.gif" alt="Date in string format"></p>
  
  <p><img src="https://i.stack.imgur.com/uXPLI.gif" alt="ParseExact Error Two"></p>
  
  <p>If anyone could help me chose the right date/time format I would be most grateful. </p>
  
  <p>Thank you!</p>