CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
We have a system with multiple membership types - at renewal, people can switch between different membership types.
Is there a query or feature available to show the date of FIRST membership irregardless of the membership type that can be displayed within Drupal Views?
The "Create Date" doesn't work for us as people can register for events (before they become members) and therefore, this would not actually reflect first date of membership.
There may be a smarter way to do this in Views, but the short version is: I would create a View that shows memberships, then create another view that shows contacts and in the latter pull in the former using Views Field Views (ie you can say, show me the results of the first view based on a match for the contact id in the second view. and set it to show only a single result per contact sorted by oldest first, and that 'should' get you what you want. Hopefully I haven't missed out too many critical steps.
