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

Date Format

fieldew1
7 - Meteor

Hi,

 

I have the following string 09-07-24 09:40:50 and I'm trying to extract date and convert it to the following format 2024/07/09.

 

Really appreciate any help with this.

 

Thanks

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @fieldew1, can't tell if this is MM-DD-YYYY or DD-MM-YYYY. Using a Formula tool expression, if it's the former then use:

 

DateTimeFormat(DateTimeParse([Input],'%m-%d-%Y'),
'%Y/%d/%m')

 

If it's the latter then you can use:

 

DateTimeFormat(DateTimeParse([Input],'%d-%m-%Y'),
'%Y/%m/%d')
fieldew1
7 - Meteor

Amazing! It did work for me :)

Labels
Top Solution Authors