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
Solved! Go to 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)
Thank you!