How to solve this error!

Help Activities
, ,
1

I have been using this expression DateTime.ParseExact ("20-Nov-23 00:00:00","dd-MMM-yy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture) .but it is throwing me a error like this

image
image1366×240 28.5 KB

when assigning to dateVar of datetime type

2

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

tmp_d74421ef-46a0-4653-9407-c1164e32f15b
tmp_d74421ef-46a0-4653-9407-c1164e32f15b1301×459 57 KB

Regards

3

Please try using the statement below,

DateTime.ParseExact(str_Date, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)

Suggested by #autopilot :slight_smile: