Answers.Body: <p>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 <a href="http://drupal.org/project/views_field_view" rel="nofollow">Views Field Views</a> (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.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-23T22:58:17.467Z
Answers.Text: Alex, pls help the health of StackExchange by updating
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-22T19:57:05.260Z
Answers.LastActivityDate: 2016-02-22T19:57:05.260Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>We have a system with multiple membership types - at renewal, people can switch between different membership types.</p>
  
  <p>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?</p>
  
  <p>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.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-22T19:18:04.350Z
Comments.Text: Alex - do your contacts maintain one membership record (which just changes type based on their selection each time), or is there one record for each membership type they've chosen over time?  If there's just one record, theoretically the join date on the membership record should work for your needs.
Comments.UserDisplayName: Lesley Carter - BackOffice
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-29T21:09:29.390Z
Comments.Text: Hi Lesley, there would be multiple membership records (so situation 1). If it was situation 2, it would make things straight forward.
Comments.UserDisplayName: Alex Katayama
Tags: <civimember>
Title: First date of first membership?
ThreadText: # First date of first membership?
  
  (Asked by: username_0 on 2016-02-22)
  
  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.
  
  **Tags:** civimember
  
  > **Comments:**
  > **username_1**: username_0 - do your contacts maintain one membership record (which just changes type based on their selection each time), or is there one record for each membership type they've chosen over time?  If there's just one record, theoretically the join date on the membership record should work for your needs.  
  > **username_0**: Hi username_1, there would be multiple membership records (so situation 1). If it was situation 2, it would make things straight forward.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-02-22. Score: 1 | Accepted answer
  
  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](http://drupal.org/project/views_field_view) (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.
  
  > **Comments:**
  > **username_2**: username_0, pls help the health of StackExchange by updating  
  
  ---
  
  