Alteryx Designer Desktop Discussions

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

Convert the Excel numerical date to date in Alteryx

sahartz
8 - Asteroid

Hi All,

 

I have an excel file with a numeric field for the Date-time and I am trying to convert it to Date-Time in Alteryx with no success.

 

In the excel the date is -

EventDate
2014-07-06 11:17:58.060
2014-07-29 09:21:14.560
2014-08-14 08:40:15.083

 

When inputting to Alteryx the date is -

41826.470811
41849.389752
41865.361286

in the format of - "Double"

 

How can I convert it to a full date and time?

 

Thanks

Sahar

4 REPLIES 4
binuacs
21 - Polaris

@sahartzuse the ToDate() function

Screenshot 2023-07-18 151139.png

sahartz
8 - Asteroid

@binuacs Thanks!!!!

binuacs
21 - Polaris

@sahartz use ToDateTime([Date]) for DateTimeScreenshot 2023-07-18 151841.png

abrasch
8 - Asteroid

I'm encountering an issue with this solution. My input is the same as the OP, coming into Alteryx as a Double. When I try ToDateTime(), the Formula tool states "Parse Error at char(50): Type mismatch in operator+. When I change the field type to a string, the expression is valid but the result is null datetime values. Any thoughts on why this is the case?

Labels
Top Solution Authors