Forum Discussion
Day to Date format
Hi, I have day of the year. I need to populate date from the day. I cant find which date function to use. I converted the data type from number to date, but it returns the previous date. with yea...
I haven't really tested this but the DATE function deals with numbers in a way that should help you.
'date calc'[day] is your 281, for example.
Column = DATE(2018,1,'date calc'[day])
Try HotChilli's solution first.
Microsoft counts date from 1st January 1900. So the 281st day happened to be the day 7th October 1900.
This silly hack may work:
Date = 'Table'[Day of the Year]+43103