Re: Adding days to a date field
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
My last post actually was for the reverse of what you want to do.
I have found no easy way of doing what you want. When I had to do it. I
called a function that basically looped through for the number of work
days desired, but as it added 1 each time it checked for a weekends and
skipped those days and also checked if the date was in the holiday
table and skipped those.
Remember to allow someone a relatively easy way of updating that
holiday table and schedule it be done at least 2 months before year end.
.
Relevant Pages
- Any reversing tips?
... I'm going on a sailing holiday in a few weeks and was hoping to get ... reverse gear is selected gently at first, ... Alternatively is it just advisable to be aware of which way the boat ...
(uk.rec.sailing) - Re: Any reversing tips?
... We went on a similar holiday last year ... and I found it difficult to control the boat when reverse gear was ... reverse gear is selected gently at first, ... Alternatively is it just advisable to be aware of which way the boat ...
(uk.rec.sailing) - Re: Putting the X back in Xmas
... if you can keep from getting upset about it, the history of ... I'm not upset about it, it's not even my holiday. ... Reverse name to reply ...
(rec.outdoors.fishing.fly) - Re: Reading in data from forms
... I am having problems with the program recognizing "HolidayDate.value" so I assume the answer to 1. ... How do I then refocus on back to my original "Schedule" form? ... In your example, rather that looping through individual records on a form, I would use the DLookup() function to check if a date exists in the Holiday table. ...
(microsoft.public.access.modulesdaovba) - Re: Commercial Calendar Calculations
... month", if Friday is a holiday, the program should schedule a Thursday ... "Find every 2nd business day of the month for 2008". ... Ready for Rails Ruby Wkshp June 23-24 Ann Arbor, Mich. ...
(comp.lang.ruby) |
|
