Forum Discussion

JeremiasBarroso's avatar
JeremiasBarroso
Qrew Member
10 years ago

How to calculate the number of years between two dates?

I have a date field to indicate an employee's start date called "Empl Svc Dt". The field is used to determine the number of years an employee has been employed. Does anyone know the best way to calcu...
roles and permissions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
Try this.  i suspect that Dan's formula will not work

This formula was for Age, but I changed it to be used for completed years of service.


var date EST = [Empl Svc Dt];

Year(Today())-Year($EST)
-
If(
Month(Today())<Month($EST)
or
(Month(Today())=Month($EST) and Day(Today())<Day($EST)),1,0)
StephanieHarris's avatar
StephanieHarris
Qrew Assistant Captain
9 years ago
I just noticed this is giving me a negative 1, I expected this for when the Date Reported was before the Employee Adjusted Service Date, however this is also happening in instances such as Date Reported = 5/23/17 and Employee Adjusted Hire Date = 1/15/2017