X amount of days from date variable
In my report I have a date variable named endDate and I'm filtering my results based on anything earlier than that date. What expression can I use to subtract 120 days from endDate? I tried using getdate(endDate) - 120 and other variants
to no avail. Any help is appreciated.
May 18th, 2011 7:28pm