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

Worked with a slight adjustment:


var date HireDate = [Employee Adjusted Service Date];

var date IncidentDate = [Date Reported];

 

 

Year($IncidentDate) -Year($HireDate)

-

If(Month($IncidentDate) < Month($HireDate)

or


Month($IncidentDate) = Month($IncidentDate) and Day($HireDate) <Day($IncidentDate),1,0)



Thanks!