excluding saturday/sunday from daily report 1

[timbaktuu]

Hello all,

I have a daily report, that has following selection formula in
record select:

{table.Timestamp}= currentdate -1 and
{table.Timestamp} in datetime(currentdate-1,time(9,0,0)) to datetime(currentdate-1,time(20,0,0))

If I run it on monday 2/14/2011 how can i default it back to Friday 2/111/2011 for interval 9 to 8 instead of going back to sunday. I tried weekdayname()<>....but it did not work.

Thanks for your help.

 

[IanWaterman]

Try

If dayofweek(currentdate) <> 2 then
{table.Timestamp}= currentdate -1 and {table.Timestamp} in datetime(currentdate-1,time(9,0,0)) to datetime(currentdate-1,time(20,0,0))
else

{table.Timestamp}= currentdate -3 and {table.Timestamp} in datetime(currentdate-3,time(9,0,0)) to datetime(currentdate-3,time(20,0,0))

 

[lbass]

Just a comment that the first line of the formula is unnecessary in that you are already limiting the records to a specific date in the second line of the formula.

-LB

 

[timbaktuu]

Thanks Ian & LB.