How to convert Generic value into Date and Time format

[ppr (Peter Preuss)]

@ppr

In addition to above. When different scenarios are to handle, we can start as described here:
[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

And extend it also for the OADates as introduced here:

Parse date into a single format

we can make use of the following building blocks: [grafik] Parsing many formats in one go ensure the following: [import_systemglobalization] arrFormats = {“dd/MMM/yyyy”, “dd-MM-yyyy”, … your other formats} DateTime.ParseExact(YourString, arrFormats, cultureinfo.InvariantCulture, DateTimeStyles.None) feel free to adapt the culture info Finally we can check which case we do have to handle e.g. with regex \d+ → OADate NA → not parseable … Bringing all together we can parse the date and…

String Not Recognized as a Valid Date Time

in addition to @supermanPunch lets have a closer look on OADates, DateStrings in 1 or more formats. An EAS read range vs. WorkBook read range can result to different column values for the date columns within the data table depending on some other factors e.g Excel cell formatting (when a new/another file is processed), Local settings of the system etc. … the value of the date column can flicker between OADates double, strings with different formats As we can see in my analysis job it was not…