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 D...
Forum Discussion
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]
not tested, but try this formula
(ToDays(Today()-FirstDayOfYear(Today()))+1) / 365 * [# of PTO Days Given]