String was not reconized as a a valid DateTime format

Question

Hi

On below code i am getting above error. Value in sessiondate is 27/12/2021 00:00:00

DateTime sessionDate = DateTime.ParseExact(colum1.SessionDate.ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture);

Thanks

Tuhin Paul · Answer

The code in my previous answer will convert the colum1.SessionDate value to a string in the "dd-MM-yyyy" format using the ToString("dd-MM-yyyy") method and then parses it back to a DateTime object using DateTime.ParseExact with the same format string. This ensures that the DateTime object is correctly parsed from the string representation with the desired format.

Tuhin Paul · Answer

you can simply convert it to a string in the desired format using the ToString method and pass that string directly to DateTime.ParseExact DateTime sessionDate = DateTime.ParseExact(colum1.SessionDate.ToString("dd-MM-yyyy"), "dd-MM-yyyy", CultureInfo.InvariantCulture); The ToString("dd-MM-yyyy") method call formats the DateTime value as a string in the "dd-MM-yyyy" format before passing it to DateTime.ParseExact.

Vishal Yelve · Answer

Hi Ramco, Try this DateTime sessionDate = DateTime.ParseExact(colum1.SessionDate.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); OR DateTime sessionDate = DateTime.ParseExact(colum1.SessionDate.ToString().trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture);

Amit Mohanty · Answer

The issue is that the format provided in the ParseExact method does not match the format of the string colum1.SessionDate.ToString() . Specifically, the format provided is "dd-MM-yyyy" but the actual format of the string appears to be "dd/MM/yyyy HH:mm:ss". Therefore, the ParseExact method is unable to parse the string into a DateTime object. DateTime sessionDate = DateTime.ParseExact(colum1.SessionDate.ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);

Jay Pankhaniya · Answer

The error message "String was not recognized as a valid DateTime format" occurs when the format of the string being parsed does not match the format string passed to ParseExact() method. In your case, you are trying to parse a string with the format "27/12/2021 00:00:00" using the format string "dd-MM-yyyy", which is causing the error. To fix this error, you need to pass the correct format string that matches the format of the input string. In your case, you can use the format string "dd/MM/yyyy HH:mm:ss" to parse the string correctly. Here is an example of how you can modify your code: DateTime sessionDate = DateTime.ParseExact(colum1.SessionDate.ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); This code should be able to parse the input string "27/12/2021 00:00:00" correctly and assign the parsed DateTime value to the sessionDate variable. Make sure to adjust the format string to match the actual format of the string you are trying to parse.