Forum Discussion

KellyKiernan's avatar
KellyKiernan
Qrew Trainee
7 years ago

Formula Help-Duration Calculation

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!
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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]