August 13, 200421 yr I'm trying to set-up a database to enter a date an employee starts work at a location and then will give me a notification when they have been there for 45 days. Also I would like it to count only Monday through Friday. Is this possible??
August 13, 200421 yr If your date field is d, then: d + 44 + If ( DayOfWeek ( d ) = 2; 16; 18 ) Would be a calculation (return type is date) that is the 45th M-F from when they started, assuming they start on a M-F. This works because if they start on monday, they'll have seen only 8 weekends (16) after 45 work days, and 9 weekends (18) if they wrap into the next week. If you wanted to change the number of days to some other number than 45 (exactly 9 weeks), the calculation would be quite different.
August 13, 200421 yr Author Thanks, It worked well. I added a script to run on startup that will beep and omit all records that meet the criteria. I then choose SHOW ALL OMITTED RECORDS and all is well in Gotham City. Thanks Much.
Create an account or sign in to comment