Universal String to Date formatted conversion

Help
, ,
1

Hi All,

As I mentioned universal is due to that we don’t have correct String format such as
(Below format data are in String datatype)

dd-mm-yyyy
dd/mm/yyyy
dd.mm.yyyy

mm-dd-yyyy
mm/dd/yyyy
mm.dd.yyyy

yyyy-mm-dd
yyyy/mm/dd
yyyy.mm.dd

So the data of these are in string format and not in datetime type.

Let me know how can I use these unformatted strings that comes from enormous datasources and convert into datetime datatype. such as dd.mm.yyyy

2

@Htwe_Ko_Ko_Wynn

Check as below for your reference
https://forum.uipath.com/t/convert-date-time-format-tutorial/242670/2

Hope this helps you

Thanks

3

@Htwe_Ko_Ko_Wynn
find some starter help here:
Parsing_MultipleFormats_DTConfig.xaml (13.0 KB)

it is showcasing following:

  • definition of multiple format patterns
  • datetime parsing
  • harmonizing the dates within a common format
  • handling parsing exception
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.