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.&nbsp;
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.&nbsp;

Any help would be appreciated!&nbsp;
Thanks,&nbsp;&nbsp;
Meagan
------------------------------Meagan McOlin------------------------------

markshnier__you · Answer

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

Forum Discussion

How many years from date

1 Reply