Manipulating Date(s) Weekends

[KHStump]

I need to send a notice to individuals whose due date is 3 days past due. This date is working days only. Is there a way to set-up the dates for weekdays only?

 

[Tiro Cupidus]

There is a function called Weekday(). Weekday(Date) will return a 1 to 7 (Sunday to Saturday). You should be able to configure whatever it is you're using to pass over 1's and 7's.

 

[KHStump]

I have a date feild called "Date_Received" and another called "Date_Complete". I need the DateDiff to be the total number of days excluding weekends. Does this need to be done in code, a module, or a query expression?

 

[KHStump]

Getting Much closer.

I used a module I found in a previous thread which defines weekdays. When I run the following it counts the days excluding weekends. That's Great!

DaysWorked: Weekdays([Date_Received],[Date_Complete])

The other thing I need is a "Due Date" which is 2 days after the Date_Received. I tried:

DueDate: Weekdays([Date_Received]+2)

This gives me an error message which says I have an incorrect number of arguments.

Can you help?