Date Format

[garretwalters12]

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?

[OmarP]

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

[cmcclellan · Accepted solution]

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 ?