Can I do something like this for the formula on "Available Vacation time" field.
This adds their anniversary vacation renewal balance every time their anniversary date comes around? Then I noticed in the dynamic form rules I can make the "Available vacation time" field every time it's simply greater than 1. This would allow the manager to subtract approved hours from their available balance throughout the year?
IF(
Today() >= AdjustYear([Start Date],15), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],14), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],13), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],12), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],11), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],10), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],9), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],8), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],7), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],6), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],5), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],4), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],3), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],2), +[Anniversary Vacation Renewal],
Today() >= AdjustYear([Start Date],1), +[Anniversary Vacation Renewal])
