How to covert the 2 date formats in my data to one

[sharmilaj]

Hi all,

My data consists of 2 date format in string shown as below

DATE

10-JAN-21

20201031

How to convert the two scenarios into one date format of dd-mm-yyyy

Thanks

[Adrian_T · Accepted solution]

Hi @sharmilaj,

Here's one way of doing it. Some key concepts:

- Use DateTime Tool to convert your original strings to Alteryx recognizable DateTime format: yyyy-mm-dd

- Use DateTimeFormat formula to format date column to your desired format (dd-mm-yyyy in your case)

[sharmilaj]

Thank you!