Date export not extracting properly into Alteryx
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
DanielCarro
8 - Asteroid
‎04-11-2024
03:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys,
Bizarre issue and I hope you guys could assist. In Excel all the dates are formatted as Date but Alteryx pulls it incorrectly, it's the only date which is incorrect.
Excel:
25/12/1987 |
21/06/2000 |
29/09/1982 |
Alteryx reading
1987-12-25
1900-01-20
1982-09-29
Any ideas why?
Note: I don't want to change the file into .csv
Kind Regards,
Dan
Labels:
- Labels:
- Developer
3 REPLIES 3
bgreedy
7 - Meteor
‎04-11-2024
04:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx presents dates in the format "yyyy-mm-dd", so it does look like you're dates are importing correctly, it's just presented in a different format in Alteryx comparted to excel.
‎04-11-2024
04:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The date 21/06/2000 is not importing correctly
alexnajm
17 - Castor
‎04-11-2024
04:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You'll have to send us your data file / workflow so we can take a look!