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
Solved! Go to Solution.
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.
Best,
Nick Michels