Convert the Excel numerical date to date in Alteryx

[sahartz]

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

[binuacs · Accepted solution]

@sahartzuse the ToDate() function

[sahartz]

@binuacs Thanks!!!!

[binuacs]

@sahartz use ToDateTime([Date]) for DateTime

[abrasch]

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?