A complex but fun Calendar Offset solution to a difficult and high-error statutory document issue
Written by Service Desk
Updated at October 12th, 2022
A statute requires a date that is the Friday following the first Tuesday of a month, which Tuesday is at least 90 days but no more than 120 days in the future. The manual error rate was horrendous and the time spent on the initial computation and the follow-on proofing burned enormous wasted time. Our programs take 1.5 seconds to reach 100% accuracy. Here's how.
Remember that Derived Answers are best hidden from form Users, done by clicking Row/Column>Show/Hide.
tags: calendar, complex, offset, Friday, Tuesday, TTEE