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])
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

By my tests, the fomula of HotChilli should solve your problem.

 

If you solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best  Regards,

Cherry