Strange double format to date

[MarcosC_]

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

[Raj · Accepted solution]

@MarcosC_ 
use formula :- todate([field])

this will convert this to date
mark done if solved.

[AndrewDMerrill]

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.

[Raj]

@AndrewDMerrill very well explained!

@MarcosC_ attaching workflow for reference.

[MarcosC_]

Hey @Raj  @AndrewDMerrill 

Thanks so much for your assistance and explanations.

I feel dumb -.-' Simpler than I was making it out to be.

It totally worked.