Convert excel numeric date time value to alteryx date time

Hello All,

I have a text file which contains a date field which holds data in the following format.

41974.48514

In excel it translates to 01-Dec-2014 11:38:36

When I read it into alteryx I am not able to recreate date time value from this number.

Kindly help.

Thanks

Amit

Date Time

Accepted answers

Try this:

DateTimeAdd(DateTimeAdd("1899-12-30 00:00:00",41974,"days"),24*.48514*60*60,"seconds")

Thanks Mike.

I tried that already before posting. Time component is very important for me and the example in the other link gives only date.

Thanks

Amit

Try this:

DateTimeAdd(DateTimeAdd("1899-12-30 00:00:00",41974,"days"),24*.48514*60*60,"seconds")