Forum Discussion

JohnDonnelly's avatar
JohnDonnelly
Qrew Trainee
8 years ago

Formula to show duration between 2 dates in order to calculate how long employee has been employed

I would like to show the amount of time an employee has been employed.  We have the following date fields; [Date of Hire] [Termination Date] as well as a checkbox field ([Active]) for if they are ...
App builders
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Not tested but try this as a formula Numeric field called [Service Years]


var date EndDate = IF(IsNull([Termination Date],Today(),[Termination Date]);

ToDays($EndDate - [Date of Hire]) / 365.25
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Missing a bracket

try this

var date EndDate = IF(IsNull([Termination Date]),Today(),[Termination Date]);

ToDays($EndDate - [Date of Hire]) / 365.25