previous days data...unless its monday

[Bloke152]

Hi Guys, im running CR9.

Im trying to get the prvious days data unless its monday, then I want to return Fridays, Saturdays and Sundys data.

I have the following in my record selection but the report is still returning wrong data.

{wmTransaction.TransactionDate} < currentdate
and {wmTransaction.TransactionDate} >
(if dayofweek({wmTransaction.TransactionDate}, 1) = 2 then
currentdate - 4
else currentdate - 2)

Since there is currently only a small amount of test data in the table, im not sure if its all data or the wrong days data its returning but it does appear to be returning everything as I have tried changed the day numbers etc.

I know nothing should be returned today but I am getting data dated the 11th.

 

[Bloke152]

dont worry guys. Sorted cheers, just needed a coffee!

 

[lbass]

Please always share your solution so that others can benefit from your threads.

-LB

 

[Bloke152]

Sorry,
It was one of those things you stare at for ages and never notice your own obvious mistake.

In the original code I posted I was picking up the day of the week of the data date, when I should have been looking at the day of the week of currentdate