The Total years as member value is rounded down to the nearest whole year if the value is not a whole number.

For active memberships:
  • The Total years as member field is calculated by subtracting Date Joined from today's date. For example, if a member joined on 1/1/2000 and today's date is 1/1/2006, the Total years as member is 5. This value does not take into account any time the membership was lapsed or dropped.
For lapsed memberships:
  • The Total years as member field is calculated by subtracting Date Joined from the Lapsed On date. For example, if the Date Joined is 1/1/2000, the Lapsed on date is 1/1/2001, and today's date is 1/1/2006, the Total years as member is 1.
For dropped memberships:
  • The Total years as member field is calculated by subtracting Date Joined from the Dropped On date. For example, if the Date Joined is 1/1/2000, the Dropped on date is 1/1/2002, and today's date is 1/1/2006, the Total Years as Member is 2.
For memberships with a Date Joined less than one year ago:
  • For memberships of any standing, if someone has been a member for less than one year, the Total years as member is 0.