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 calculate the number of year(s) as a single number "0, 1, 2" etc. between the current date and "Empl Svc Dt"?
This formula was for Age, but I changed it to be used for completed years of service.
var date EST = [Empl Svc Dt];
(Month(Today())=Month($EST) and Day(Today())<Day($EST)),1,0)