Forum Discussion

JohnDonnelly's avatar
JohnDonnelly
Qrew Trainee
7 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
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
Alexandraochoa's avatar
Alexandraochoa
Qrew Trainee
6 years ago
I've tried this and it worked perfectly, but how do I get this in number of day? Do I need to switch to duration?

I am doing mine based off of DATE SENT TO LAB & REPORT DATE. Any help would be appreciated. Thanks