Convert Number Format into Date Format

[Cfdiaz2103]

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.

[JagdeeshN]

Hi @Cfdiaz2103 ,

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

Best,

Jagdeesh

[KarolinaRoza · Accepted solution]

hi @Cfdiaz2103 

You can try this:

Karolina

[phottovy · Accepted solution]

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 ☹️

[KarolinaRoza]

hi @Cfdiaz2103 

please see my simply workflow. It is working,.

Karolina