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!
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!
@Empower49,
A good read for you: https://community.alteryx.com/t5/Engine-Works-Blog/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/ba-p/181500?author_id=3557&collapse_discussion=true&filter=includeBlogs,includeTkbs,authorId&include_blogs=true&include_tkbs=true&q=frustration&search_type=thread
Cheers,
Mark
Thank you very much for sharing! That will be a fabulous resource.
Sol
