SOLVED
Converting 28-Jun-2019 String to Date field
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AboutBlank
6 - Meteoroid
‎07-09-2019
07:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
acastelazo
8 - Asteroid
‎07-09-2019
09:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you use dd-Mon-yy format, it seems to work...
‎07-09-2019
10:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Absolutely spot on - thank you so much,
