Forum Discussion

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 ...

Ask about Quickbase functionality

Formulas and functions

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

JohnDonnelly
Qrew Trainee
8 years ago
Thank you for the quick response. I receive the following syntax error with the formula above;
Formula syntax error

Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.

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

ToDays($EndDate - [Date of Hire]) / 365.25
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
JohnDonnelly
Qrew Trainee
8 years ago
That works perfectly, thank you so much.
Alexandraochoa
Qrew Trainee
7 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
QuickBaseCoachD
Qrew Captain
7 years ago
Please post your formula