Dynamic Filters/Prompts

[system]

My report contains a column called ‘Date Record Added’. I want to schedule the report to run every two weeks where ‘Date Record Added’ is between ‘today’ (=CurrentDate()) and ‘ten days ago’ (=RelativeDate(CurrentDate();- 10)). I’m open to using Dynamic Filters or Dynamic Prompts or other ideas. How do I accomplish this?

---

Larry Loew (BOB member since 2016-08-23)

[MarkP]

You’re better create universe objects for Today and Ten Days Ago. This thread will give you full details, depending up your backend database.

You can then use a query condition of:
Date Record Added between Ten Days Ago and Today and this can then be run/scheduled whenever you want.