[AccessD] Days Past Due - Grace Period

Gustav Brock gustav at cactus.dk
Thu Sep 4 08:56:17 CDT 2003


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



More information about the AccessD mailing list