String was not recognized as a valid DateTime

Question

User-240513752 posted

  DateTime CheckInDate = DateTime.ParseExact(txtCheckIn.Text, "yyyy-MM-dd HH:mm:ss,fff",
                                        System.Globalization.CultureInfo.InvariantCulture);
here txtCheckIn.Text =9/9/2015 12:00:00 AM


run time error occuring "String was not recognized as a valid DateTime. "

Answer 1

User2103319870 posted

Khan_1

DateTime.ParseExact(txtCheckIn.Text, "yyyy-MM-dd HH:mm:ss,fff",

You are using wrong date format in DateTime.ParseExact method. when using ParseExact you need to pass  the date input as exact format which we mentioned in code

Try with the below code

//Convert the text value to Datetime
DateTime CheckInDate = DateTime.ParseExact("9/9/2015 12:00:00 AM", "M/d/yyyy h:mm:ss tt",System.Globalization.CultureInfo.InvariantCulture);
//Your Required format
string reqval = CheckInDate.ToString("yyyy-MM-dd HH:mm:ss,fff");

• Sample Working Demo

Answer 2

User-484054684 posted

Hi, your string is not in the same format as you have defined. There is mismatch.

See from MSDN documentation as below (So you need to make sure the dateString (in your case txtCheckIn.Text) matches with the format.

// Parse date and time with custom specifier.
      dateString = "Sun 15 Jun 2008 8:30 AM -06:00";
      format = "ddd dd MMM yyyy h:mm tt zzz";
      try {
         result = DateTime.ParseExact(dateString, format, provider);
         Console.WriteLine("{0} converts to {1}.", dateString, result.ToString());
      }
      catch (FormatException) {
         Console.WriteLine("{0} is not in the correct format.", dateString);
      }