Darn!!!!
Terry gets the big prize. I could REALLY use the income!!!!
Still, I will offer a comment. Terry's soloution works - for the problem as stated. There ARE a few issues which I am sure will soom arise.
First, if anyone ever gets more than the five days it is a gonner. Beyond that, if the span includes a company (a-la 7/4/xxxx, it will count aginst vacation. This may not be agreeable to employees.
Next, we should consider wheather the entry could/would include 'weekends'. Again, just using the example, Joe has 7/1/01 through 7/4/01 schedualed as "VACATION" who wants to work for a company charging him vacation time for the Sunday (7/1/01) AND a national Holiday? Better yet, what supervisor will be accepting the report? Is the supervisor going to be in the office Sunday (7/1) or Wednesday (7/4) checking that "Joe Blow" did actually take the day off?
I might be tempted to do this for a LOT less than!$$$$$1,000,000.00 - but not without some discussion on the merits/needs of the overall situation.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over