Datetime convert error

[Ritaman_Baral]

I am facing the errror : String was not recognized as a valid Date Time

I have checked the value from datatable is there

[ppr (Peter Preuss)]

Hava a look at least at the first part which helps on further analysis steps

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[Ritaman_Baral]

not working…i tried it

[ppr (Peter Preuss)]

its about the analysis in the first step

• please share with us the samples from the dates from immediate panel
• please share with us the analysis of all non parseable values from the immediate panel

thanks

[supermanPunch (Arpan)]

@Ritaman_Baral

I have checked the value from datatable is there

Hi @Ritaman_Baral ,

Is the Value from the Datatable dates value in the format of yyyy-MM-dd ?

Then, I believe you would need to correct the format that you have specified in the DateTime.ParseExact() method. (notice the small mm used in your expression)

However, If it is not of the format that you have specified, then you would need to change the format accordingly as present/retrieved from the Datatable.

[postwick (Paul Ostwick)]

The value may be there, but it doesn’t fit the yyyy-mm-dd format probably because mm is minutes, while MM is month. Change it to yyyy-MM-dd, and make sure that’s the exact format of the value, that it doesn’t have a time on it or a single digit month (M) or day (d).