Date Time Parse

[supermanPunch (Arpan)]

@pl.rusinov

returns error Assign: String ‘03/13/2023 07:57:00’ was not recognized as a valid DateTime. does not format the date in dd/ММ/yyyy format

@pl.rusinov ,

In that case we would ask you to Check with the Below Post. Or Perform a Debug and check the value of the Datatable in the Locals or Immediate Panel.

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

We should be able to find different formats of date values in it. Once identified we can use those formats within the DateTime.ParseExact() method to parse the date properly.

Also, You could Check with the below Expression :

dateFormats = {"dd/MM/yyyy","MM/dd/yyyy HH:mm:ss"}

dt.AsEnumerable.Where(Function (x) x("Type of order").ToString = "Close Account" andAlso DateTime.ParseExact(x("Date and time of order sent").ToString, dateFormats,System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).DayOfWeek.ToString = "Monday").Count

Here, dateFormats is a type of String Array variable.