P
pdorsey
How can I exculde the number of holidays when counting the total number of
days between two dates?
days between two dates?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Where are your holidays defined? There are about 100 holidays on my desk
calendar. Does your Access application know which ones are valid?
Have you done a search for this? There are several samples out there to
help you build in this feature. It is not nearly as simple as your question
implies.
Rick B
calendar. Does your Access application know which ones are valid?
Have you done a search for this? There are several samples out there to
help you build in this feature. It is not nearly as simple as your question
implies.
Rick B
P
Paul Overway
You would need a table listing all holidays...then query for holidays
between a given set of dates. Then subtract the number of holidays found
from the elapsed number of days.
between a given set of dates. Then subtract the number of holidays found
from the elapsed number of days.
M
M.L. Sco Scofield
Take a look at the second example at
http://www.mvps.org/access/datetime/date0006.htm.
There are also a bunch of date routines at
http://www.mvps.org/access/datetime/date0012.htm that might be of interest.
Good luck.
Sco
M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
http://www.mvps.org/access/datetime/date0006.htm.
There are also a bunch of date routines at
http://www.mvps.org/access/datetime/date0012.htm that might be of interest.
Good luck.
Sco
M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com