Business owners wanted a report with a hard coded date range rather than a date range prompt. Customer is always right, especially in an economic downturn. I could not figure out how to do this and after a couple of days of trial and error I got this to work. I hope this saves someone some time.
--get past 30 days
[Business View].[Sales Tracking Transaction].[Sale Date]between _add_days(current_date,-30) and current_date
--get past year
[Business View].[Sales Tracking Transaction].[Sale Date]between _add_Years(current_date,-1) and current_date