How to autodate a report. to run daily showing 7 days history to two days before current date?

[capronton]

How to autodate a report to run daily showing 7 days history to two days before current date? For example the report for today should show the dates below:

4/20/14
4/21/14
4/22/14
4/23/14
4/24/14
4/25/14
4/26/14

What formula would I used and how can I add the formula to the Selection Criteria?

Thanks for any assistance.

 

[Charliy]

you could either do this all in the select formula or create individual formulas for the start and end dates.
I prefer having start and end sate formulas because you may need to reference them more than once.

@startdate
beforereadingrecords;
currentdate - 8

@enddate
beforereadingrecords;
currentdate - 2

Then just use them in your select or group formula like this:

{table.date} in {@startdate} to {@enddate}

 

[capronton]

Thanks, this was very helpful!