Workday Function in Approach

[Ellie]

In my approach database I need a field to add on 13 working days to the date the record was made. I know that there is a workday function in lotus 123 but it does not appear in approach. Any ideas what I can do??

 

[suesloan]

Use a calculated field and the DayOfWeek() to get the number of the day in the week (Sunday is 1, Monday is 2, etc). Then you can figure out the number of weekends to include in the calculation.

DOW = DayOfWeek(yourdatefieldname)

NewDate = yourdatefieldname + If(DOW = 7,5,If(DOW = 1 or DOW = 2 or DOW = 3,4,6))

This takes care of weekends, but not holidays.

Sue Sloan

http://www.xpertss.com