Hi, I wonder if somone could help?

I am trying to use the select expert to select the next coming saturday and sunday only on the report.

I have tried a mixture of things but cant get it to work...


{date} = today + 1 and {date} = today + 2 which does not work.

I cant use an actual date as the report will need to be run every friday to retrieve sat and sun.

Any help would be great please.

Hi

here works a formula to always return a date that happens to be a Thursday. If its sunday thru wednesday the first part of the if statement runs, if its fri or sat, the else part runs.

shared Datevar Thur;

if Dayofweek(CurrentDate)<=5 then
Thur:= CurrentDate - Dayofweek(CurrentDate)+5 else

Thur:= CurrentDate - Dayofweek(CurrentDate)+12;
//when the date is 1/3/14 then dayofweek is 6. 1/3/14 minus 6+12 same as 1/3/14+6 which is 1/9/14
//when the date is 1/4/14 then dayofweek is 7. 1/4/14 minus 7+12 same as 1/4/14+5 which is 1/9/14