There is no rolling over, saving, accruing of PTO (Flat 14 days per year, if you were employed the entire year). So each Jan 1 everyone with a start date prior to that day would be reset to 14.
------Original Message------
Mark,
Before you go further, what are the business rules about rolling over PTO? If an employee goes all year and [Days Used]=0, what is the correct answer on January 1st the next year?
Is it 14?
Does it drop to zero?
Is there a cap on total amount you can accrue? There are places you can have earned 60 days PTO if you are saving them.
This would change how you architect your solution.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------