[AccessD] Days Past Due - Grace Period

Hi Virginia

I think Search is searching the site, not the archive.
Pick the link to the month ordered by subject.

/gustav


> 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