Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to exclude weekend?

Status
Not open for further replies.

sc11pio

Technical User
Jul 10, 2003
20
SG
Hi,
I created a form call Notes ID request. In the form, I have 2 fields, "Creation_Date" and "Date_Receive"

The user will receive the ID after 10 days started from Creation_Date (which it only counts the working day)
For example,

The "Creation_Date" is on 1 Oct, the user should be receiving the ID on 15 Oct ("Date_Receive").

How can I do this?

Reg,
Pio
 
You need to first use the @adjust function, then check the result with @weekday and @adjust more if necessary.

Try it out and come back to us if you have problems.

Pascal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top