I am trying to create an AR Aging report that will show outstanding invoice data based on date-buckets. I have used a parameter to create the end date, but I'm not sure how to create the date ranges automatically based on the EndDate parameter. For example, if the user selects May31, 2011 as the end date, I need to be able to select from my invoice table the data for 30-60 days over due. I can easily get 30-60 days ago from today with GetDate, but how can I get 30-60 to calculate from May 31?

Hi, I believe your report parameter is of type date. You can use this parameter in functions like DatADD() to calculate your date ranges. Something like DateADD(dd, -30/-60, @EndDate). If you need more details, please post your query here.MSBI Developer