Dates Transformation with different formats

[shanu_s9]

Hi All,

Please help for the below issue.

i have two columns with dates, one column with DD/MM/YYYY, DD-MMM-YY & DDMMYYYY format, how to convert all in one format.

Dates

29/09/2019

26-Sep-19

20092019

another column with DD/MM/YYYY, DD-MMM-YY & DDMMYYYY format, additional 'YYYYMMDD' how to convert all in one format.

Dates

29/09/2019

26-Sep-19

20092019

20190910

[tresesco]

You can use date#() and alt() in combination. One example is here : Handling multiple date formats 

[shanu_s9]

Thanks it's working...