community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Converting 28-Jun-2019 String to Date field

Meteoroid

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!

Highlighted
Asteroid

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

Capture.JPG

Meteoroid

Absolutely spot on - thank you so much,

Labels