Our employee's vacation days renew on January 1 each year. Our employees always ask "How many vacation days will I have on January 1 next year?". I would like to create a Calculation Field to show this. Let's call it "VacationNextYear". I obviously also have a field for "HireDate".
Our vacation policy states the following: If on January 1, you have been employed for 6 months, you will receive 7 days of vacation. Also, if you have been employed for more than 1 year, you will also receive an additional day for each full year you have been employed.
I've lost track of EVERYTHING that I've tried so far, so I can not list them all. In general, here is what I'm thinking about doing (with no success so far):
Calculation Field "VacationNextYear":
Date(1;1;Get(CurrentDate)+1) - HireDate > 365 ;
Year(Get(CurrentDate)) - Year(HireDate) + 7;
Month(HireDate) <=6 ; 7 ;
This seems straight forward, but I must me missing something simple. Like I said, I've tried many variations of this with no luck. I've tried calling out the long version of the HireDate (ex: Date(Month(Date of Hire);Day(Date of Hire);Year(Date of Hire)) ), but that didn't seem to work either. In the above if statement, I always get results for Current Year - HireDate + 7.
Thank you in advance for your input!