I Have Whole number date column to date and time format

[Anonymous]

I have column name with whole number like below for date.

i need to add another column to show whole number date to normal date column like below.

[HotChilli · Accepted solution]

You can parse it as a number but it will be easier to change datatype to text then change it to date (or use one of the Power Query functions like Date.FromText).

Once it's in date format you can change it to datetime