Hi,
In the report builder, I create a report with the criteria Date Completed is between today and 7 days before today (date of report generation). As expected, the report when I run it contains data between today and 7 days ago. I save the report and then schedule it to run and email me the data once a week. Unfortunately, that 7 does not remain a 7, it increases over time, so next week I get data between today and 14 days ago, etc.
Since the filter is a relative one rather than an absolute, is there a reason that it appears to be saving with a static date, and can this be changed so that it works as might be expected?
Regards
Dan