Formula Help-Duration Calculation

  • 0
  • 1
  • Question
  • Updated 1 week ago
  • Answered
I'm new at building formulas in Quickbase. I need to build a formula that will calculate accrued employee PTO time (it's accrued daily).
Simply put, it would be as follows:

(Today's Date - First Day of Current Year +1)/365*# of PTO Days Given

# of PTO Days Given is a field in a report. I'm not sure if I need to create another field to build the formula in to get the calculation or if I just need to add a calculated field to a report.

Any help for this novice would be greatly appreciated. Thank you in advance!
Photo of Kelly Kiernan

Kelly Kiernan

  • 120 Points 100 badge 2x thumb

Posted 1 week ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
You should create a new formula numeric field called [accrued employee PTO time]

not tested, but try this formula

(ToDays(Today()-FirstDayOfYear(Today()))+1) / 365 * [# of PTO Days Given]

Photo of Kelly Kiernan

Kelly Kiernan

  • 120 Points 100 badge 2x thumb
Brilliant! That worked! Thank you so much!