Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • HotChilli's avatar
    HotChilli
    7 years ago

    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])
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

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