How do you automatically update report date range?

[MichaelCreatura]

We produce a report every Tuesday at 4pm based off of multiple ServiceNow reports.

In order to get the data, we open each report individually and update the 'Created' conditions to say that the report should contain records created between 'Last Tuesday' at 16:00 and 'Current Day (Tuesday)' at 15:59:59. For example, this week we updated the conditions on each report to say that they results should be Created Between 31/05/2022 at 16:00:00 and 07/06/2022 at 15:59:59. 

Is there a way of automating this (or using a dynamic filter) so that we don't have to manually enter new dates each week when running the report? 

Many thanks in advance for any advice! 

[Ankur Bawiskar]

@MichaelCreatura 

Hi,

you need to calculate the today's date then subtract 7 from it and update the filter

Check the link I shared where I provided solution

Can we write script to change reports filter condition?

If my response helped please mark it correct and close the thread so that it benefits future readers.

regards
Ankur