How many years from date

Question

Hello,

I am looking for a code that will tell me how many years have passed from a certain date. 
For example, we have a field for an employee's Start Date. I would like another field to calculate how many years they have been working here based on today's date.

Any help would be appreciated! 
Thanks,  
Meagan
------------------------------Meagan McOlin------------------------------

MarkShnierYou · Answer

try this as a numeric formula fieldvar date HireDate = [my hire date field];Year(Today())-Year($HireDate)-If(Month(Today())<Month($HireDate)or(Month(Today())=Month($HireDate) and Day(Today())<Day($HireDate)),1,0)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community