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

Adobe

Accepted answers

Hi @dunkindonut7777

Here is how you can do it.

Workflow:

Hope this helps : )

All comments

Hi @dunkindonut7777

Here is how you can do it.

Workflow:

Hope this helps : )

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-p/24370

Best,

Nick Michels

Quick Links

Tags

This months top contributors

Hollingsworth 335