Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to convert "44664" number into date

Ekmi9
8 - Asteroid

I have Date in excel as "4/13/2022" but when i load that file into alteryx that time it will show as "44664".

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

Datetimeadd("1900-01-01", [field],"days")

 

1 would represent 01 Jan 1900

 

i think that this should aid you. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-convert-the-Excel-numerical-dat...

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors