String was not reconized as a a valid DateTime format

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.

 

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.

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);

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);

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.