RELATED IDEAS
Allow relative dates for report options
It would be great if we could set relative dates in the options for a report. So, for example, we could set a date range for "last month" so that the report doesn't need to be updated after a month rollover.
I know that excel formulas can be used to replicate this functionality, but being able to pull just the data from the table for the range needed is a lot more efficient than pulling the entire table and using excel to filter what is necessary.
I have been thinking about this, I have a few reports that are "Current month + Last Month" that are scheduled for daily or weekly runs that would be nice to be able to have it auto update as the month crosses over. and I know a trending 12 month report is common as well, but currently you would have to change the report option monthly. I know it is slightly different as I think you are talking about manually runned reports rather than scheduled, but this would help on the scheduled reports I have.
This would be very nice. Currently the workaround we use is to create a hidden sheet in the report and use formulas to calculate the dates based off the =Today() if a date range was not manually entered, set excel links for the calculated dates, then use those excel links in the filters for your date ranges, but this is cumbersome to setup.