CONVERTING DATE FROM MULTIPLE FORMAT

[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)
02-DEC-18	2018-12-02
2018-03-29	2018-03-29
05-MAR-2018	2018-03-05

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

[atcodedog05 · Accepted solution]

Hi @dunkindonut7777 

Here is how you can do it.

Workflow:

Hope this helps : )

[NicholasM]

Hey @dunkindonut7777, 

An Alteryx employee a ways back did make a tool that would do this dynamically, meaning you wouldn't need to build out a complex formula. I would recommend looking into this and see if it works for you. 

https://community.alteryx.com/t5/Engine-Works/Introducing-BB-Date-Date-Parsing-for-the-Rest-of-Us/ba...

Best,

Nick Michels