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.
SOLVED

Text date to date format

carterfleming
8 - Asteroid

How do you convert "Oct 03, 2023" to "10/03/2023"?

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @carterfleming, I'd personally use the following expression in a Formula tool - just replace [Date] with your own field name of course:

 

DateTimeFormat(DateTimeParse([Date],'%b %d, %Y'),'%m/%d/%Y')
carterfleming
8 - Asteroid

Perfect, thank you!

Labels
Top Solution Authors