In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How can I use Alteryx to change date format?

phoebe_90
8 - Asteroid
 
For example
change 2023-09-15 to 09/15/2023

 

 

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @phoebe_90 you can do this multiple ways using a a formula such as Datatimeformat or the data time tool.

 

Datetimeformat_22092023.JPG

 

However I should add that Alteryx only recognises YYYY-MM-DD as a date format while you can transform your date in MM/DD/YYYY it will have to be or convert into a string field. Otherwise it be null if it was date data format. 

EdwardCochrane
7 - Meteor

There is a specific date time parse tool that makes this very easy. I suggest using that unless you have a good reason for using a formula.

Labels
Top Solution Authors