How to covert Multiple DATEs ( Data type : String) convert to Date format (DD:MM:YYYY)

[Anjankumar2021]

How to covert Multiple DATEs ( Data type : String) convert to Date format (DD:MM:YYYY)

[gaoa]

Hi @Anjankumar2021 

You can use this formula: DateTimeFormat([Sale date],"%d/%m/%Y")

[KimLamNg]

You can transpose to have all the dates in one column then convert data type from string to date. However, the standard date format in Alteryx is "yyyy-mm-dd", so I don't think it possible to have the desired outcome.