Strange double format to date

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

Alteryx reading source data format.PNG

Original excel file .xlsx

Excel source data format.PNG

Thanks for the help,

Marcos

Parse

Date Time

Accepted answers

Raj

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

this will convert this to date
mark done if solved.

All comments

Raj

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

this will convert this to date
mark done if solved.

CoG

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

@CoG very well explained!

@MarcosC_ attaching workflow for reference.

3161.yxmd

MarcosC_

Hey @Raj @CoG

Thanks so much for your assistance and explanations.

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

It totally worked.

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157