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 DateDate1Date32022-12-312021-12-312020-12-31 I tried formula to format but all they were giving me error Output: DateDate1Date312/31/202212/31/202112/31/2020

How to change the date formate

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

Datasets

Date Time

Common Use Cases

Accepted answers

Felipe_Ribeir0

Hi @Sshasnk

You can use this formula

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

All comments

ShankerV

Hi @Sshasnk

This can be achieved using Formula tool.

Many thanks

Shanker V

Felipe_Ribeir0

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.

How to change the date formate.yxmd

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.

Sample WF - Date.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703