When viewing the Total Years on a Membership record, if the current membership standing is Lapsed, the Total Years is incorrect. The Total years should be calculated based on the Joined on date of the specific membership record by subtracting the Joined On date from the latest Expires On dates.
However, users may see incorrect results for Lapsed memberships. The Total Years is incorrectly calculated using the oldest Joined On date (of any membership on the constituent's record), rather than the Joined On date of the specific Lapsed membership.
Note: This does not occur for the Total Years for memberships in a Dropped or Active standing, as this calculates correctly, even if a constituent has other memberships with earlier Joined On dates.
This will be resolved in 7.96 patch 13, released in September - October 2018 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, when available.