Dynamic date filter

[system]

Good Morning Everyone,

I have report which is filter out by object “WeekEndDate”

For ex: Where Weekend Date <= 2007-04-21

This report is run every Sunday and each time I run the report I have to change the week end date to select last week data.

How can I create dynamic filter so that I don’t have to manually change the date every Sunday?

This is the end result I’m looking for: If have to run report today the end date should be <=2007-04-21….If I have to run this report next Monday (2007-04-30) then end date should be <=2007-04-28.

Thanks In Advance

---

DesiGuju (BOB member since 2007-04-23)