Date Formatting (dd-Mon-YYYY)

[Empower49]

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!

[Kenda · Accepted 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")

[Empower49]

You are my hero. I knew this had to be simple. Thanks so much for being willing to help out a beginner!

[Kenda]

@Empower49 

Absolutely! That's what this community is all about :) 

[MarqueeCrew]

@Empower49,

A good read for you:  https://community.alteryx.com/t5/Engine-Works-Blog/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/...

Cheers,

Mark

[Empower49]

Thank you very much for sharing! That will be a fabulous resource.

[aries00719]

Sol