Trying to change date format to "MM/DD/YYYY" but struggling...

[joewils92]

I've trying to use the parse tool to change the date format in MM/DD/YYYY as that's the only way my system will receive the input. I've tried from date format and string but neither seem to like it so appears i'm going wrong somewhere. I'm a bit of an alteryx noob so any help is massively appreciated!

Many thanks

[Bren_Spill · Accepted solution]

@joewils92 - DateTimeFormat([Journal Date],"%m/%d/%Y")

Refer to this guide to understand the logic: DateTime Functions (alteryx.com)

[Deano478 · Accepted solution]

@joewils92 give this formula a try

DateTimeFormat(DateTimeParse([Journal Date],'%Y-%m-%d'),'%m/%d/%Y')

[griffinwelsh · Accepted solution]

@joewils92I recommend using the datetimeformat function within a formula tool:

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

See https://help.alteryx.com/current/en/designer/functions/datetime-functions.html## for other date time formatting help.

[joewils92]

Thanks so much all!

[Ankur_BDO]

The Dates provided in the Text Input tool are already in Date format. To change the format you can use the Formula tool as given in the screen shot or check out the attached file.