Date conversion (format 24MAY2018)

[Helenet]

Hi all, 

I have a string with dates in the format "24MAY2018" and want to convert it into a real date. Can someone help me with that? 

Thanks. 

/Helene

[Thableaus · Accepted solution]

Hi @Helenet 

Check this documentation on how to parse dates with DateTimeFunctions.

https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm

You can use DateTimeParse function

DateTimeParse([Date], "%d%b%Y")

Cheers,

[jdunkerley79 · Accepted solution]

I suggest a formula tool with expression:

DateTimeParse([Input],"%d%b%Y")

[BenMoss]

You can use the datetimeparae tool and then use custom mode, I think the statement ddMMMyyyy would work in this instance but my syntax might be slightly off!

I'm sure someone will correct me quite quickly if I am!

Ben