I'm developing a product for my HR department that will calculate vacation time and such based on date of hire all beginning after 6 months and will vary on the length of time the employee has been here.
I'm having problems figuring out some of the logic. Say I enter a employee who's hire date is today which would be less than six months. An entry would be created in the database for vacation used as 0.
Now, the problem comes in how I check each employees record every day and when it comes time for their 6 month or 2 year anniversary to update the record with the appropriate amount of time.
Any help on this logic would be greatly appreciated.