how to filter weekends

[pranvera]

Try:

SELECT MarDaily.*
FROM MarDaily
WHERE (((MarDaily.[Req Delivery Dt/Tm])>= iif(datepart("w",date()) <=4 ,date()-5,date()-3)));

YES, this works correctly. Thank you!



Hope last question: will same formule work for days older than 3 days (same issue with weekends) like:

<= iif(datepart("w",date()) <=4 ,date()-5,date()-3

[slave138]

YES, this works correctly. Thank you!

Hope last question: will same formule work for days older than 3 days (same issue with weekends) like:

<= iif(datepart("w",date()) <=4 ,date()-5,date()-3

It should, but only if you remember the closing parentheses:

<= iif(datepart("w",date()) <=4 ,date()-5,date()-3)

Also, you might want to be careful to include a bottom limit or you will get *everything* older than 3 weekdays.

[pranvera]

thanks all of you for help!