Answers.Body: <p>I think you can do this via Find Members since to be an Active Member on that date you need</p>
  
  <ul>
  <li>a start date before that date AND</li>
  <li>an end date after that date</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-30T09:41:57.240Z
Answers.Text: After a bit of trial and error, best way to achieve Peter's solution is to use Search Builder.
Answers.UserDisplayName: Tony Horrocks
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-30T19:16:27.567Z
Answers.Text: did you try our extension? https://github.com/fuzionnz/nz.co.fuzion.historicmembershipdata
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-31T08:11:29.127Z
Answers.Text: I did not! Thanks Peter.
Answers.UserDisplayName: Tony Horrocks
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-26T22:19:59.070Z
Answers.Text: Just used this extension because I did not have logging enabled and it allowed me to asnwer some questions. Petednz is the civi savior.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-07T01:23:14.557Z
Answers.LastActivityDate: 2016-03-07T01:23:14.557Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I've been asked to mine CiviCRM to determine how many active members we had on a particular date in the past, i.e. How many active members did we have on Dec 31, 2015?   Is there a search or report that will show me this?</p>
  
Tags: <civimember><search><reports>
Title: How do I determine how many active members there were on a date in the past?
ThreadText: # How do I determine how many active members there were on a date in the past?
  
  (Asked by: username_0 on 2016-03-06)
  
  I've been asked to mine CiviCRM to determine how many active members we had on a particular date in the past, i.e. How many active members did we have on Dec 31, 2015? Is there a search or report that will show me this?
  
  **Tags:** civimember, search, reports
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-03-07. Score: 2
  
  I think you can do this via Find Members since to be an Active Member on that date you need
  
  * a start date before that date AND
  * an end date after that date
  
  > **Comments:**
  > **username_2**: After a bit of trial and error, best way to achieve Peter's solution is to use Search Builder.  
  > **username_1**: did you try our extension? https://github.com/fuzionnz/nz.co.username_1.historicmembershipdata  
  > **username_2**: I did not! Thanks Peter.  
  > **username_3**: Just used this extension because I did not have logging enabled and it allowed me to asnwer some questions. username_1 is the civi savior.  
  
  ---
  
  