change column dd-mm-yy with month in alphabetical format.

[ShantanuDagar]

Hi,

I have a column with the format examples: 2-Feb-22, 13-Jan-19, 8-Nov-14

I need to change this to valid date format.

Any help would be appreciated....

Thanks

[OllieClarke · Accepted solution]

Hi @ShantanuDagar you can use the datetime tool to do this: https://help.alteryx.com/20223/designer/datetime-tool

Use the custom format

dd-Mon-yy

Hope that helps,

Ollie