Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Format

garretwalters12
8 - Asteroid

I originally had a string field in a column as 04/27/2019, when converting from string to date using the DateTime tool, the column now shows the cell formatted as 2019-04-27. How can  I format the date field of 2019-04-27 to 04/27/2019?

2 REPLIES 2
OmarP
Alteryx Alumni (Retired)

Well, you can use DateTime Tool to convert back from date type to string showing 04/27/2019 - but you end up having the same result. Are you looking to check if he incoming date is a valid DateTime format?

 

Date type is always showed as 2019-04-27

 

More help here https://help.alteryx.com/current/DateTime.htm

 

2019-05-21_00-21-10.293.png

cmcclellan
13 - Pulsar

All dates in Alteryx are yyyy-mm-dd.  You can use DateTimeFormat to create a string from that, but if you're not doing any math with dates then leave it as a string maybe ?

Labels