[AccessD] MSAccess 2007 - Count days

Kostas:

I did this for my MRP system to calculate Order Date from Due Date  minus
lead time.  But never found a slick way to doit other than looping
backwards, starting with the due date, checking each date to see what day of
the week it was and also checking the holiday calendar to see if it was a
holiday - and decrementing a lead time counter each date that was determined
to be a work day.  Works fast enough but it's definitely brute force.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: Thursday, November 15, 2007 11:50 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] MSAccess 2007 - Count days

Hi all,

Does anybody know how it could be possible to count the work days between
two days excluding weekends and local holidays To my coutry there are
several dates as holidays and some of them are moving year by year

many thank's to all

/kostas
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.15.32/1131 - Release Date: 11/14/2007
4:54 PM