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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Does this work?

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

 

Hope this helps.

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

Sorry for the delay. Other projects were taking precedence.  Yes, this does work.  Thank you.

 

Do you have an explanation as to why my formula did not work?  Problem solved, but the mystery still exists.

 

In either case, thank you.

 

Phil