Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Date Format

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?


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



Alteryx Partner

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 ?