Next work day

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Next work day

Post by D Willett »

Using the WorkDays module, can I return the next working day as criteria in a query?
A sub report I use returns results for Date()+1, it is always an issue on a Friday because it returns Saturday data which doesn't exist.
Our workdays are Mon to Fri. If the report is run onb a Friday ideally it should return Monday data.

Could do with a little help with the syntax for the criteria if possible.
You do not have the required permissions to view the files attached to this post.
Cheers ...

Dave.

User avatar
HansV
Administrator
Posts: 78589
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Next work day

Post by HansV »

If you are using the code from http://access.mvps.org/access/datetime/date0012.htm" onclick="window.open(this.href);return false; use

dhNextWorkdayA()
Best wishes,
Hans

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Re: Next work day

Post by D Willett »

Looking pretty good ....

Returning the next work day..

Thanks Hans
Cheers ...

Dave.