If Condition: String was not recognized as a valid DateTime

[ppr (Peter Preuss)]

Kindly note:

First 2 samples are demonstating Conversion Options
Third sample is about showing the -0400 ignoration

We can see the baselined time part. On midnight borders it can result to a different date. So the cutoff can maybe risky

When the handling of multiple formats is needed we can do:

taken from:

[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…