Report Condition: Created between Last Friday and This Friday

[Blair5]

Is there a way to create a condition on a report for incidents created between last Friday at 4 and this Friday at 4. I don't want to hard code dates and would like to have this dynamic. I tried:

1. Created "ON" Last 7 Days

2. Created "Relative" "On or After" 7 Days ago

This report is set to be scheduled on Fridays at 4. Initially I thought the above 2 conditions would work, but if someone gets the email of this report later than the information may not be correct. Any ideas are appreciated.

[Chuck Tomasi · Accepted solution]

Hi Blair,

This sounds like you might have to build yourself a dynamic filter (or two) where you can write the script to calculate the date from last Friday and this Friday.

Create a dynamic filter option

[SNOWBeginner1]

Hi Chuck,

Do you have any reference of the script that we can use.

I have a similar requirement

[chaselong]

Hi Blair,

Were you able to get this to work and if so would you mind posting the calculation script you used? I can think of several use cases for this at my organization.

[Blair5]

Chase,

No - we decided not to pursue the development of this type of report.