Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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