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