Forum Discussion
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
var date EndDate = IF(IsNull([Termination Date],Today(),[Termination Date]);
ToDays($EndDate - [Date of Hire]) / 365.25
JohnDonnelly
7 years agoQrew Trainee
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.
ToDays($EndDate - [Date of Hire]) / 365.25