Convert Number Format into Date Format

Hi everyone!

I'm trying to figure out how Alteryx could convert a value from Number Format (Typically Excel General Format) into the corresponding Date Value, but I haven't got any success.

For example: Convert the value "44407" into this value "30/07/2021"

I'd appreciate any help from you, guys.

Date Time

Accepted answers

KarolinaRoza

hi @Cfdiaz2103

You can try this:

Karolina

phottovy

I think this post will give you what you are looking for:

Solved: Serial date to calendar date time in a custom format

Edited:

I didn't even think to try the ToDate formula but thanks to @KarolinaRoza , I now know this is possible. Much easier solution.

All comments

JagdeeshN

Hi @Cfdiaz2103 ,

Can you please elaborate on what each digit(44407) in the number means.

Best,

Jagdeesh

KarolinaRoza

hi @Cfdiaz2103

You can try this:

Karolina

phottovy

I think this post will give you what you are looking for:

Solved: Serial date to calendar date time in a custom format

Edited:

I didn't even think to try the ToDate formula but thanks to @KarolinaRoza , I now know this is possible. Much easier solution.

Cfdiaz2103

Hi @KarolinaRoza!

It´s not working ☹️

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703