Forum Discussion
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...
Hi,
Does this work?
=IF('Date'[Date]>=TODAY()-365,"CY365",IF('Date'[Date]>=TODAY()-730,"PY365",BLANK()))
Hope this helps.
Hi,
Does this work?
=IF('Date'[Date]>=TODAY()-365,"CY365",IF('Date'[Date]>=TODAY()-730,"PY365",BLANK()))
Hope this helps.
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