I'm trying to find a way to calculate Networkdays in a
access query, but can't find the function.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Do you mean total work days? Try EndDate - BeginDate. But, then
there is the question of what is a work day? Mon-Fri? What about
holidays? Most solutions I've seen & created include the use of a
Holiday table that holds the dates of the various holiday dates (per
year) the company observes. The idea was to subtract the number of
holidays that occur between the dates in question. To ignore weekend
days I once wrote a function to calculate how many weekend days were
between 2 dates. Then substract that value from the interval between
the 2 dates. E.g.:
(EndDate - BeginDate) - HolidayDays - WeekEndDays
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQEz/YYechKqOuFEgEQLcbQCgq+xsMkcIXgblmg/cocTlytZEbTMAnjEq
bs2bGESaMflGIgcG9Xv3N7t8
=Nyuw
-----END PGP SIGNATURE-----
