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.
Next work day
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Next work day
You do not have the required permissions to view the files attached to this post.
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 78589
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Next work day
If you are using the code from http://access.mvps.org/access/datetime/date0012.htm" onclick="window.open(this.href);return false; use
dhNextWorkdayA()
dhNextWorkdayA()
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Re: Next work day
Looking pretty good ....
Returning the next work day..
Thanks Hans
Returning the next work day..
Thanks Hans
Cheers ...
Dave.
Dave.