Dates

[jpac]

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??

[The Shadow]

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.

[jpac]

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.