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

Many strings in format yyyy-mm-dd , convert to date format dd-MMM-yy

wonka1234
10 - Fireball

Hi,

 

Is it possible to convert many columns from yyyy-mm-dd (these are strings) to date dd-MMM-yy in one formula?

 

Thanks.

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @wonka1234 yes use the datetimeparse and datetimeformat formulas in the multi-field tool and it should convert all the fields.

wonka1234
10 - Fireball

@JosephSerpis 

 

DateTimeFormat([_CurrentField_],"dd-MMM-yy")

 

doing this.. but literally getting that.. how to use datetimeparse here?

FinnCharlton
13 - Pulsar

Hey @wonka1234 , use this formula in a Multi-Field formula tool, ticking all the fields you want changed.

datetimeformat(
datetimeparse([_CurrentField_],'%Y-%m-%d')
,'%d-%b-%y')
JosephSerpis
17 - Castor
17 - Castor

Hi @wonka1234 I mocked up an approach. The datetimeparse formula would be needed as you mentioned your dates were in a string format. So parse into a date format before using the datetimeformat formula to output into the format you need.

 

Multi_field_13092023.JPG

 

 

Labels
Top Solution Authors