I have set up an employee table with a DateofHire field. I need to get the date of hire from the Employee table and calculate how many months each employee has worked, and based on the length of time use accrual rates for vacation time:
13 days if worked less than 1 year;
14.50 days if worked 1-4 years;
16 days if worked more than 4 -6 years;
19 days if working more than 6 years.
So there are 2 parts to the issue: determine months worked, and based on results apply accrual rate to each employee's vacation time.