Help String Date

[KellyCom]

Ok after a few tries i am posting here for some help as nothing i do seems to fix this

I have a csv coming in as a string and looks like :  14-May-2021

I am wanting to convert this to a date and have tried the DATETIME parse tool but results in blanks .  I tried also parsing out the string to 3 separate fields and then trying to mash it together for a date and it all results in blanks for me.  

Any ideas /thoughts?

[alexnajm · Accepted solution]

What is the issue? Seems to work for me!

[abacon]

@KellyCom What are your configurations for the DateTime parse tool? 

[Qiu · Accepted solution]

@KellyCom 
We can go with DateTime tool as shown by @alexnajm  or as  you mentioned, with a DateTimeParse function in Formula tool.

I think you may have used the incorrect specifiers, and here is the list of specifiers in DateTime function.

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html##

[KellyCom]

this worked - thank you !  I was selecting an output in the selections above vs using the custom.  I need to be better about writing them myself.  thank you !