CONVERTING STRING (MULTIPLE FORMAT) TO DATE

[dunkindonut7777]

Hi I would like to ask if how can I convert the unusual date that has a string type of data to date format.

Date (String)	Expected output (Date)
01-DEC-2020	2020-12-01
2020-03-18	2020-03-18
05-MAR-2018	2018-03-05

How can I convert it according to the date format? Thank

[atcodedog05]

Hi @dunkindonut7777 

Here is how you can do it.

Workflow:

Hope this helps : )

[messi007]

@dunkindonut7777,

Please see below :

Attached the workflow,

Regards,

[binu_acs]

@dunkindonut7777 

IIF(!isNull(DateTimeParse([Date (String)],"%d-%b-%Y")), DateTimeParse([Date (String)],"%d-%b-%Y"), DateTimeParse([Date (String)],"%Y-%m-%d"))