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

[wonka1234]

Hi,

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

Thanks.

[JosephSerpis]

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

[wonka1234]

@JosephSerpis 

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

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

[FinnCharlton · Accepted solution]

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]

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.