i am writing a report that needs to do the following:
show all records in a table that have a removed date in a column within the last 7 days.
every time the report runs it should only return those records that have a removal date within the last 7 days
any help would be appreciated