[AccessD] Days Past Due - Grace Period

I tried that, all I saw was Calculate Age. I opened that post and this is
all that was in it:

Skipped content of type multipart/alternative-------------- next part
--------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1219 bytes
Desc: not available
Url :
http://databaseadvisors.com/pipermail/accessd/attachments/20030808/b5d3a562/
attachment.jpeg


Any ideas???

Va.

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Thursday, September 04, 2003 11:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [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

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