Trying to add years to a date field for PTO Accrual Tracking

  • 1
  • 1
  • Question
  • Updated 4 months ago
  • Answered

I have an HR report I'm trying to replicate in QB that exists in Excel currently. We have a standard PTO Accrual tier based on an employee's hire date. As they reach these milestones, HR modifies their accrual rate in the HR system. They track a list of employee's and hire dates in Excel and have to manually review the list. I'm trying to build this feature in QB and leverage the Notifications so that they're alerted when they need to address a PTO accrual change.
In Excel, I'm able to add years to a date field but in QB I'm only able to add Days (that I can tell). When I add days, I'm off a few due to leap years and what not. I know my formula isn't the most efficient way to go and certainly didn't know if there is a way to more accurately increase the Years on a Date field.
Photo of Lee Gilmore

Lee Gilmore

  • 762 Points 500 badge 2x thumb
  • I should know better

Posted 4 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
no problem,
Use the AdjustYear function


https://login.quickbase.com/db/6ewwzuuj?a=dr&r=bd&rl=qzf
Photo of Lee Gilmore

Lee Gilmore

  • 762 Points 500 badge 2x thumb
That's exactly what I needed. Kicking myself for not seeing that function but very much appreciate the direction! Thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Here's a link to bookmark for all the functions

https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000132
Photo of Lee Gilmore

Lee Gilmore

  • 762 Points 500 badge 2x thumb
Perfect, I'll be referencing this often!