I have a Date field formatted "YYYY-MM" representing the year and month members joined our Service Club. I now wish to create a Date Calculation Function in the member's "Seniority Pin" field that determines how many years of service they have contributed from joining until TODAY().
So far the member record on line 8 has the member "Seniority Pin" record field as: =YEARS(E8;TODAY();Type)
I'm not sure I'm doing this correctly or what "Type" the function is looking for.
Any assistance would be appreciated.
Thank you.