# Error: String '' was not recognized as a valid DateTime

**URL:** <https://forum.uipath.com/t/error-string-was-not-recognized-as-a-valid-datetime/773517>\
**Category:** Studio\
**Tags:** workflow-diff, question, studio, system, activities\
**Created:** [October 15, 2024, 9:25am UTC](https://forum.uipath.com/t/error-string-was-not-recognized-as-a-valid-datetime/773517 "2024-10-15T09:25:18Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![ashokkarale](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ashokkarale/32/474400_2.png) [@ashokkarale](https://forum.uipath.com/u/ashokkarale)\
**Post date:** [October 15, 2024, 9:56am UTC](https://forum.uipath.com/t/error-string-was-not-recognized-as-a-valid-datetime/773517/4 "2024-10-15T09:56:43Z")

</div>

@rajababu.mandapati,

Use this snippet. You can add all possible formats in the array and it will always give you output in “dd/MM/yyyy”

```auto
strOutputDate= DateTime.ParseExact(inputDateVariable, {"dd/MMM/yyyy","MM/dd/yyyy","dd.MM.yyyy"}, CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

```

Learning Resource:

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

\*\*Added missed ToString format at the end.  
\*\*Added learning resource

---

_[View the full topic](https://forum.uipath.com/t/error-string-was-not-recognized-as-a-valid-datetime/773517)._