Date format from mm/dd/yy to DDMMMYYY format

[Inactive User]

Team,
I want to convert mm/dd/yy format to DDMMMYYYY format... for example 03/19/21 to read as 19Mar2021 - if i use DateTimeParse tool its not accepting and shows an warning as " Formula (24) DATETIMEPARSE: Cannot convert "2021-03-19" to a date/time with format "%d-%B-%Y" and language "English": Invalid month: '2021-03-19' -- expected at least three letters".

Please advice.

Regards,

Guru

[Luke_C · Accepted solution]

Hi @Inactive User 

Try this:

datetimeformat(datetimeparse([Date],"%m/%d/%y"),"%d%b%Y")

Datetime functions can be tricky, I have this bookmarked:https://help.alteryx.com/current/designer/datetime-functions 

[Emil_Kos · Accepted solution]

Hi @Inactive User,

I have prepared a workflow for you.

Output:

[Inactive User]

Thanks all !