In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Date Format issue

AKPWZ
8 - Asteroid

Hi again,

Trying to solve a date format issue that I encountered today, I would really appreciate it if someone could tell me what 45021.28263 is and how to change it to 3/31/2023 15:03:07.

Thank you

5 REPLIES 5
binuacs
21 - Polaris

@AKPWZ I am getting a different date value

binuacs_0-1682665043278.png

 

Qiu
21 - Polaris
21 - Polaris

Excel shows a bit different also.

Qiu_0-1682666843088.png

 

PhilipMannering
16 - Nebula
16 - Nebula

You can also do,

ToDateTime([Date])
anandakrishnan
8 - Asteroid

@binuacs 

👍

caltang
17 - Castor
17 - Castor

Using ToDateTime(ToNumber([Date])) gets me this result. 

caltang_0-1682674481018.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors