Converting String To Date

[SamYX]

I have a string as 2-January-2019 , how can i convert to date format as native DateTime tool doesn't help 

Or my apologies i can't solve it

Please advise  

[MarqueeCrew · Accepted solution]

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

DateTimeParse([your field],"%d-%B-%Y")

i feel your pain!

 Cheers,

Mark

[LordNeilLord · Accepted solution]

Hey @SamYX 

DateTimeParse([Field1], "%d-%B-%Y")  is what you'll need.

You should also bookmark this page as it has everything you need to know about datetime functions in Alteryx: https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

[SamYX]

Thanks a Lot...A lot to learn

[SamYX]

Thanks a lot...sure i will save the link as bookmark

[aman_goyal · Accepted solution]

[Henrytabares]

Thanks for sharing! Absolutely useful! Regards. Henry