converting number to date time

KNiranjan

HI All,

how to convert number to date time field in alteryx. below formula is not working for me. Please suggest. 

DateTimeAdd(DateTimeAdd("1899-12-30 00:00:00",TODATE(Field),"days"),86400*TODATETIME([Field]),"seconds")

Field
44378.0024
44378.00286
44378.00317
44378.00324
44378.00348
44378.0038
44378.00385
44378.00396

atcodedog05

Hi @KNiranjan 

Just use ToDateTime() function

Workflow:

Hope this helps : )

Todatetime.yxmd