How to change the format of a DateTime Stamp

[KCAgentProvocateur]

Hi There, 

I currently have a string in the format of MM/dd/yyyy and id like to change it to the datetime of dd/MM/yyy

Appreciate the help!

Thanks,

[MarqueeCrew]

@KCAgentProvocateur ,

You can use the datetime tool or use an expression like this one:

DateTimeFormat([DateTimeField],"%d/%m/%Y")

AND save it to a string.

Cheers,

Mark 

[RolandSchubert · Accepted solution]

Hi @KCAgentProvocateur,

you can use a formula:

DateTimeFormat(DateTimeParse([Field1], '%m/%d/%Y'), '%d/%m/%Y')

The result will be a string field, date type is always YYYY-mm-dd in Alteryx.

Best,

Roland