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