Forum Discussion

psmith-nhs-inc's avatar
psmith-nhs-inc
Icon for Helper III rankHelper III
8 years ago
Solved

DateAdd() math cutting off at year mark

OK.  I have a calculated column on my Date table.  I want to know if any particular date is within the last 365 days of today, or the previous 365 days.  I think this should give it to me.  Looking a...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Does this work?

    =IF('Date'[Date]>=TODAY()-365,"CY365",IF('Date'[Date]>=TODAY()-730,"PY365",BLANK()))

     

    Hope this helps.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi psmith-nhs-inc,

 

Have you solved your problem?

 

If you have solved, could you share your solution or 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 share your data sample and your desired output, so that we can help further investigate on it?

 

Best Regards,

Cherry