Changing the Date Format

[brian_mcdonough]

Hi - The date from my input is "2023-01-01" and I need this to be 1/1/2023. It's coming in as a date type. When I use the DateTime tool to convert it to a MM/dd/yyyy (string), nothing changes. How can I convert it to 1/1/2023 with a formula tool or why is it not being changed with the DateTime too? Thank you

[BS_THE_ANALYST]

Seemed to work for me! Cross reference mine with yours. See attached 

[BS_THE_ANALYST]

Check the metadata aswell (see attached). Just to definitely check that it's in Alteryx as a Date datatype

[Luke_C]

Hi @brian_mcdonough 

Here's an example of both:

[Christina_H]

The DateTime tool won't change the existing field from being a date field, it creates a new field (DateTime_Out by default) containing the formatted date.  This can be easy to miss in a large data set, have you checked all the columns?

Alternatively the formula you need is DateTimeFormat([Date],"%m/%d/%Y"), but this will also need to be in a new field as you're changing the data type.