Reports that have been created with a dynamic date range (eg. last 7 days, year to date) automatically update the date range every time they are refreshed.


To change the date range for a report that has been created with a custom date range, go to the report sheet, change the date range, and press the Refresh button (see image below).



If you have lots of reports with a custom date range and want to change the dates for all of them, you can unhide the querystorage sheet and set the start and end dates there.