Hi Mark,
I appreciate your quick responses!. I'm not the best at explaining but here is what i have:
- Field: Amount of Time Accrued Per Pay Period
If([Years Of Service]<=5, 3.33,
[Years Of Service]=6, 5,
[Years Of Service]=7, 5,
[Years Of Service]=8, 5,
[Years Of Service]=9, 5,
[Years Of Service]=10, 5,
[Years Of Service]>=11, 6.66)
- Field: YTD PTO Accrued
(Month(Today()) * [Amount of Time Accrued Per Pay Period])
So, for example me. I've been here for over 11 years so i fall under 6.66 hours accrued per pay period
so as of today i should have 39.96 if we go by the beginning of the year. What i want is to go off of the anniversary year aka Date of Hire.
Now, here's another curveball. the 39.96 is wrong because we get paid bi-weekly(every two weeks), so my total should really be 79.92 if we go by the start of the year. I Hope I'm explaining myself correctly. I appreciate your time :)
------------------------------
Don Quixote
------------------------------