DATE AND TIME FORMAT

[jonick1205]

hello everyone,

Good day!

Just want to ask how can i show this format date MM/DD/YYYY since the default format date for altreryx is YYYY-MM-DD

[apathetichell]

using formula:

to convert to date:

datetimeparse([yourfield],"%m%d%Y") (to a new date field)

to convert from date:

datetimeformat([yourdate field],"%m/%d/%Y") to a string field.

[Qiu]

@jonick1205 
We can also use DateTime tool