[AccessD] Days Past Due - Grace Period

I tried a search on this page, for Calculating Days. But nothing happens, I
don't think the search is working. I entered it at the top of the page & in
the middle of the text.

http://www.databaseadvisors.com/archive/archive.htm#



-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Thursday, September 04, 2003 8:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Days Past Due - Grace Period


Hi Virginia

> PastDue: DateDiff("d",[DateEntered],Now())-5
 
> Oh! Get this, I just got an email from mgmt, they want the days past due
to
> count "Buisness Days only". So it does not count weekends & holidays!! I
> can't figure out how to make it count to 5 let alone skip weekends. :-(

Not a big problem. Do as Rocky suggests: use a function to calculate
the difference in working days; if this is bigger than five days, fire
your boss's request message, if not don't.

Look up the archive for August and the subject "Calculating days".

/gustav

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