Date conversion topic

[duaine.b (D)]

I have a date Thu 10 Nov 2022 and I’m using (Date.ParseExact(CurrentRow(“Column-0”).ToString,“ddd dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture) to convert it into a date but I’m getting the error If: String was not recognized as a valid DateTime.

Why is this

[Jithesh_R]

Hey @duaine.b ,
Try this

DateTime.ParseExact("Thu 10 Nov 2022", "ddd dd MMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Output :

Note : Output Value is of type String

Regards,