Converting 28-Jun-2019 String to Date field

[AboutBlank]

Hello All,

As per the title I am trying to convert the date flowing through my excel sheet as string in Alteryx into Date so I can sort from Newest to Oldest.

I get the following error when trying to use the DatTimeParse Formula on a string field presented as:  28-Jun-2019

Formula (105) DATETIMEPARSE: Cannot convert "28-Jun-2019" to a date/time with format "%d %b %Y": Invalid month: '-Jun-2019' -- expected at least three letters

All help would be much appreciated.

Thank you!

[acastelazo · Accepted solution]

If you use dd-Mon-yy format, it seems to work...

[AboutBlank]

Absolutely spot on - thank you so much,