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 : )

[KNiranjan]

@atcodedog05 Thanks for your reply, It is dynamic field

when i tried with same i got the blank information

[atcodedog05]

Hi @KNiranjan 

Can you provide more info on what do you mean by its dynamic field?

[KNiranjan]

@atcodedog05 when i tried same formula it is not working for me. 

[atcodedog05]

Hi @KNiranjan 

Can you try this

ToDateTime(ToNumber([Field ]))

Can you please share a snapshot of the issue you are facing.

[KNiranjan]

@atcodedog05 Sorry for my later reply, Here is the error message 

[atcodedog05]

Hi @KNiranjan 

Did you try running the workflow once remove new1 formula and try running it once.

[KNiranjan]

@atcodedog05 Yes i tried after removing the New1, but still im getting blank data. 

[atcodedog05]

Hi @KNiranjan 

The possibility is there might be leading/trailing spaces can you try this formula

ToDateTime(ToNumber(Trim([Field]," ")))

If this doesn't work can please share me the sample data in files.