How to change the date formate

[Sshasnk]

I have a date format in which yyyy-mm-dd which I have to change it into mm/dd/yyyy. I want to do this to multiple columns So I don't wanna use the datetimeParse tool

Example

Date	Date1	Date3
2022-12-31	2021-12-31	2020-12-31

I tried formula to format but all they were giving me error

Output:

Date	Date1	Date3
12/31/2022	12/31/2021	12/31/2020

[ShankerV]

Hi @Sshasnk 

This can be achieved using Formula tool.

Many thanks

Shanker V

[Felipe_Ribeir0 · Accepted solution]

Hi @Sshasnk 

You can use this formula

datetimeformat([Date], "%m/%d/%Y")

[ShankerV]

Hi @Sshasnk 

I tried formula to format but all they were giving me error

You are getting the error because the input is in Date format and the Output you are trying to store in the same column is not date format which is dd/mm/yyyy. 

Hence you need to store in the temp column and rename using select tool or Dynamic select tool.

Many thanks

Shanker V

[ShankerV]

@Sshasnk 

\

Please find the below expected solution.

[Christina_H]

Alteryx will only display date fields in the format yyyy-mm-dd.  To change the format you need to convert it to a string field.  Since you're converting multiple dates, you can use a multi-field formula tool to convert them all at once.

[PanPP]

Hi @Sshasnk 

I have provided a sample WF that achieves your output.