PeopleSoft - writing a report that continually looks back 7 days when run on recurrence

Question

I'm trying to write a query in Query Manager that I intend to put on a recurrence. Right now, I have a field that is using the DATEADD sql code and it works well for my needs.

The problem is, this is a new hire report and I want it to look back 7 days every time it's run. I would think the code would be something like this:

DATEADD(DAY, -7, Current Date (EffSeq = Last))

The problem is that I cannot figure out how to input it properly into the criteria so that the report will run properly.

Does anyone have a solution?

Answer 1

I finally stumbled upon the answer - which is similar to Robin's, but slightly different: