Simple Date Criteria, Exclude Weekends

[bigchicagobob]

Hello,

I am attempting to write a query that filters out Orders placed within 2 days of today. Orders can be placed on Monday-Friday, but not placed on Saturday or Sunday. This is a problem for the criteria come Monday because it counts Saturday/Sunday. How can I exclude saturday and sunday from the count?
Essentially, if an order is on monday, I dont wan't the criteria to count sunday/saturday, but to start on friday.



Here's what I have written. I've tried using datediff() and weekday() to no avail.




Order Date: IIf([Order #] Is Null And [qry orders].[order entry date]<Date()-2,"2 days with no order","")


Thank you,

[June7]

One way:

Order Date: IIf(IsNull([Order #]) And [order entry date] < Date()-Switch(Weekday([order entry date])=2,4, Weekday([order entry date])=3,5, Null,2),"2 days with no order","")


Advise no spaces or special characters/punctuation (underscore is exception) in name convention.

[bigchicagobob]

June,

Your suggestion helped tremendously. I made a few adjustments to your suggestion because I did not phrase my issue well. Regardless, I now have it working. Thank you.