Date is converting incorrectly after Parse
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
slawrie5
5 - Atom
‎09-21-2021
11:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi. I am having an issue with a date that is formatting incorrectly after parsing.
The original field contained 9/11/21-9/13/21. I parsed it to 2 new fields and then used a Data Cleansing tool to auto format the date as YYYY-MM-DD .
However, one of the dates is switching all of the characters around so it is showing as if the date is November 21 2009 instead of September 11 2021.
How do I fix this issue?
Labels:
- Labels:
- Topic of Interest
3 REPLIES 3
Alteryx
‎09-21-2021
12:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KarolinaRoza
11 - Bolide
‎09-21-2021
01:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @slawrie5
Agreed with @Garabujo7 , you can use Date Time tool.
Please find my proposed configuration of this tool. It should work. Let me know if you still have issue with your data.
Regards,
Karolina
17 - Castor
‎09-21-2021
01:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @slawrie5
I agree with the above replies, here's an alternative using the datetimeparse function:
