How to solve this error!

Hi @Kancharla_Mahija

If you using Read Range Workbook there is option in properties panel, Preserve Format option enable that and give the below syntax:

DateTime.ParseExact ("11/20/23", "MM/dd/yy", System.Globalization.CultureInfo.InvariantCulture)

Or else for your condition also please check below

DateTime.ParseExact("21-Nov-23 00:00:00","dd-MMM-yy HH:mm:ss" , System.Globalization.CultureInfo.InvariantCulture)

Please check the below image the output extracted perfectly


1 Like