Query that shows previous workday and Friday-sunday on mondays.

[jtmott]

Hello, I'm new to access and I am trying to write a query that shows the orders that came in on the previous workday but on Mondays it will show the orders that came in on last Friday-Sunday. I'm trying to use the following code and it does work well for Tuesday-Friday but on Monday it does not return anything.


IIf(DatePart("w",Date())=2,(([Ordercat].[ORDERDATE]) Between DateAdd("d",-3,Date()) And Date()-1),DateAdd("d",-0,Date()))

I would appreciate any help you can give.

[Dal Jeanis]

WHERE 
   [Ordercat].[ORDERDATE]
 BETWEEN 
   IIF(Weekday(Date)=2,DateAdd("D",-3,Date),DateAdd("D",-1,Date)) 
AND 
   DateAdd("D",-1,Date)

It can all be run together on one line, but I broke it out for legibility.

[jtmott]

Thank you
That works great.