Days of week

[ptrifile]

Was wondering if someone could give me some guidance. I am looking to automatically schedule a report and when it is run i would like the report to show data by day of week.....

So if the report runs on Tuesday it will show Mondays data:

11/08/2010 Data Data Data

When the report runs on Wednesday it will show both Monday and Tuesday

11/08/2010 Data Data Data
11/09/2010 Data Data Data

and so on so that when the report is run on the following Monday it will show Monday - Sunday....can someone help me accomplish this?

Thanks for any help or suggestions.

Paul

 

[lbass]

if dayofweek(currentdate,crMonday) <> 1 then
{table.date} in currentdate-dayofweek(currentdate,crMonday)+1 to currentdate-1 else
{table.date} in currentdate-7 to currentdate-1

-LB

 

[ptrifile]

Thanks lbass, i have tried a couple of different ways of using this formula but im not getting the desired results. So i tried using the formula in a formula field and then grouping on that formula field and i get a "True" next to the data.

Should i be using it differently?

Thanks again

Paul

 

[lbass]

This formula is intended as a record selection formula. Go to report->selection formula->record and enter it there.

-LB