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!

Register Log in
  • Congratulations Rhinorhino 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

sc11pio

Technical User
Joined
Jul 10, 2003
Messages
20
Location
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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pmonett
  • Locked
  • Question Question
Script to make a PDF from a Word document - execution issues
Replies
0
Views
1K
pmonett
pmonett
MrWilson
  • Locked
  • Question Question
button click to send mail
Replies
0
Views
952
MrWilson
MrWilson
cmaynard
  • Locked
  • Question Question
Domino Directory view to show user's mail template
Replies
1
Views
1K
hume
hume
mastro78
  • Locked
  • Question Question
R5 - How to avoid duplicate data entries
Replies
3
Views
1K
pmonett
pmonett
mlorencak
  • Locked
  • Question Question
how to catch every new document in mail.box
Replies
0
Views
231
mlorencak
mlorencak

Part and Inventory Search

Sponsor

Back
Top