3I'm creating a calendar that lists various recurring due dates for reports and status updates. For end-of-year reports, I choose the "Last weekday of December" option. However, 31 Dec is a company holiday. I'd like to have this report fall due on 30 Dec.
While I could easily do this with a lookup on the exisiting dueDate fields and an calculated "newDueDate-takingCompanyHolidaysIntoAccount" column, I'm wondering if there's a way to access the list(s) that populate the's calendar "add new task" dialog box to save that extra step?
I would like to define an additional menu option; last workday of the month with a list of company holiday dates. I could then define dueDate as such:
dueDate = if ((lastWeekday is-in-holidayList) and (lastWeekday = "Monday")) then dueDate = dueDate - 3 else dueDate - 1;
...recursively until my dueDate fell on a workday.
Any ideas?