Add 72Hrs to a Date Exclude wknd

[Guest]

Hi, I have been searching through this site for 3 hours now searching for a
solution....to no avail. Here is my problem...

I have a Date Received column and I need to add 72 hours (SLA) to the [date
received]. I do not want to include the time between 8:00 pm Friday evening
and 7:59 AM Monday morning....and excluding holidays would be a bonus - but
I'd be happy with just eliminating the weekends.

(Example: Received datetime = (Thurs) 4/21/2005 01:00:00 PM Add 72 HOUR SLA
Time = (Tues) 4/26/2005 01:00 AM )

I am leaving the US to move to Australia in 6 weeks and would like to
"impress" my co-workers one last time beofre I leave...lol I won't give up
on this....but help would be greatly appreciated!

Regards..... Jami

 

[Michel Walsh]

Hi,



use 3 times dhNextWorkdayA from
http://www.mvps.org/access/datetime/date0012.htm


Hoping it may help,
Vanderghast, Access MVP