Strange double format to date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I tried a couple of community posts on similar problems but the doubles that people had issues with usually were the dates just unformatted.
I can't share the workflow nor the data since it's confidential but it's an extraction coming from a company software.
In the excel it appears in a "valid" format DD/MM/YYYY, but Alteryx reads it as double with just 5 numbers.
Might be my fault but I also can't make the ToString formula work to then use the Parse DateTime to help me.
Select tool also only identifies as double / int number type data and doesn't give me the Date option which would fix it entirely.
Alteryx read
Original excel file .xlsx
Thanks for the help,
Marcos
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarcosC_
use formula :- todate([field])
this will convert this to date
mark done if solved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The format you are seeing is the number of days since January 1, 1900 (which I believe is how excel stores dates on the backend). @Raj is exactly correct, you can use the ToDate() function to convert this number to a date (just make sure you are adding a new Date-type column and not trying to modify the pre-existing "double"-type column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
