community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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?

Alteryx
Alteryx

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

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 ?

Labels