# Date Time Parse

**URL:** <https://forum.uipath.com/t/date-time-parse/527972>\
**Category:** Studio\
**Tags:** datatable, studio, system, activities\
**Created:** [March 21, 2023, 7:35am UTC](https://forum.uipath.com/t/date-time-parse/527972 "2023-03-21T07:35:49Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![supermanPunch](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/supermanpunch/32/133652_2.png) [@supermanPunch](https://forum.uipath.com/u/supermanPunch)\
**Post date:** [March 21, 2023, 8:37am UTC](https://forum.uipath.com/t/date-time-parse/527972/7 "2023-03-21T08:37:43Z")

</div>

> [@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.

> [@ambulance sos \[FirstAid\] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues](https://forum.uipath.com/t/firstaid-datatable-debug-analysis-invalid-datetime-strings-string-to-datetime-parsing-issues/418641):
>
> This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a 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 tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", CultureInf…

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 :

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

```

```auto
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.

---

_[View the full topic](https://forum.uipath.com/t/date-time-parse/527972)._