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')

[Hammad_Rashid]

Please try Find Replace Tool.

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

[binuacs]

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

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

[NMangera · Accepted solution]

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

[MikeFrancis1959]

This works !

Thanks

Mike