date format

MikeFrancis1959

The data I use is not in the date format I need for Alteryx and I have tried a few ways to change it but no luck, I know I am missing something simple but I cannot get it correct, can someone help me on this?

convert date 2023.01.03 to 2023-01-03

I used this formula

datetimeparse([Input], '%d/%m/%Y')

Workflow

Accepted answers

NMangera

you can also use the DateTime tool. Set the configuration to Custom and type %Y.%m.%d

All comments

Hammad_Rashid

Please try Find Replace Tool.

https://help.alteryx.com/20223/designer/find-replace-tool

binu_acs

@MikeFrancis1959 You have to use the same input format in the DateTimeParse() function

DateTimeParse([input],'%Y.%m.%d')

NMangera

you can also use the DateTime tool. Set the configuration to Custom and type %Y.%m.%d

MikeFrancis1959

This works !

Thanks

Mike

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703