Forum Discussion
QuickBaseCoachD
Qrew Captain
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)
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)
QuickBaseCoachD
7 years agoQrew Captain
Try this
var date HireDate = [My Hire Date field];
var date IncidentDate = [My Incident Field];
Year($IncidentDate -Year($HireDate)
-
If(
Month($IncidentDateToday()) < Month($HireDate$EST)
or
(Month($IncidentDate) = Month($IncidentDate) and Day($HireDate <Day($IncidentDate),1,0)
var date HireDate = [My Hire Date field];
var date IncidentDate = [My Incident Field];
Year($IncidentDate -Year($HireDate)
-
If(
Month($IncidentDateToday()) < Month($HireDate$EST)
or
(Month($IncidentDate) = Month($IncidentDate) and Day($HireDate <Day($IncidentDate),1,0)