Weekday Only Calc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aMack - 11 Feb 2008 15:37 GMT

I am generating reports for a customer based on activity for the previous 2
working days. There is no activity on weekends, therefore i need the query
results of: "[Arrival Date]=Now()-2" to exclude weekends.

Help.

Thanks

Signature

A MACKENZIE, CMA, MBA

Reply to this Message

Marshall Barton - 11 Feb 2008 16:40 GMT

>I am generating reports for a customer based on activity for the previous 2
>working days. There is no activity on weekends, therefore i need the query
>results of: "[Arrival Date]=Now()-2" to exclude weekends.

Try using:

DateAdd("d", - 2 + 2 * (WeekDay(Now(), 2) < 3), Now())

ir, if that's too cryptic:

DateAdd("d", - 2 - IIf(WeekDay(Now(), 2) < 3, 2, 0), Now())

Signature

Marsh
MVP [MS Access]

Reply to this Message