I am trying to convert 12-FEB-2019 to 2019-02-12. I used the parse tool and a formula tool with no luck. I'm sure this is an easy fix, does anyone have a solution? Thank you!
Solved! Go to Solution.
Hey @Empower49
If you want to use a Formula tool, create a new field, choose Date as the data type, and use this expression:
datetimeparse([Field1],"%d-%b-%Y")
You are my hero. I knew this had to be simple. Thanks so much for being willing to help out a beginner!
A good read for you: https://community.alteryx.com/t5/Engine-Works-Blog/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/...
Cheers,
Mark
Thank you very much for sharing! That will be a fabulous resource.