Skip to main content
Question

Formula Help-Duration Calculation

  • December 6, 2018
  • 0 replies
  • 53 views
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!
    This topic has been closed for replies.

    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]

    • KellyKiernan
    • Author
    • Registered
    • December 6, 2018
    Brilliant! That worked! Thank you so much!
    Terms & ConditionsAccessibility statement