DDMMMYYYY Date Format

[agrawaluk]

Hi,

I have a column with dates in DDMMMYYYY (3Mar2020) format. Alteryx is not able to recognize this using either select tool, date time tool or datetimeparse. Can some one help me out to get it into a date recognizable format? For sample just enter a text input with 3Mar2020 and try to convert it. Thanks

[Simha · Accepted solution]

Hi,

Here's a solution. Please don't forget to accept the solution if you like.

Simha

[JosephSerpis · Accepted solution]

Hi @agrawaluk if you use this syntax in a formula DateTimeParse([Date],"%d%b%y") it will convert you date into a format that alteryx recognise. I've attached a workflow showing this.

[agrawaluk]

Wow, I didn't know that capital letters are recognized, this solves a lot of my problems. Thanks!