Answers.Body: <p>UPDATE: also try the <a href="https://github.com/fuzionnz/nz.co.fuzion.historicmembershipdata" rel="nofollow noreferrer">nz.co.fuzion.historicmembershipdata extension</a></p>
  <p>Try the <a href="https://civicrm.org/extensions/membership-churn-reports" rel="nofollow noreferrer">Membership Churn</a> extension otherwise</p>
  <p>1/ I think you can get via</p>
  <p>Adv Search</p>
  <p>Set Start Date to &lt; Feb 26 2019</p>
  <p>Set End Date to &gt; Feb 26 2019</p>
  <p>2/ might be a bit trickier but I suggest using Search Builder and something like</p>
  <p>Set Start Date &gt; Jan 1 2019 to Dec 31 2019</p>
  <p>OR</p>
  <p>Set End Date to &gt; Jan 1 2019 to Dec 31 2019</p>
  <p>EDIT: you may need to also exclude Memberships that are 'old' ones which you may be able to do via Memb Status</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-27T16:22:59.820Z
Answers.Text: Follow-up question, Pete: Using the search filters, how do I search for specifically "Set Start Date to < Feb 26 2019" or "Set End Date to > Feb 26 2019"? I mean, what exactly do I put in the "Choose Date Range" fields?
Answers.UserDisplayName: NHPHA Executive Assistant
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-27T19:01:59.400Z
Answers.Text: for the first example in the Start Date you would leave the 'from' field blank, and put the desired date in the To. so it says, show me all results that started before date x. then in the End date field you say 'show me all results where the End Date is 'after'' hence you put the date in the 'from' and nothing in the 'to'.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-27T19:02:57.343Z
Answers.Text: hoping my logic is hte right way round. not looking at Adv Search as i wrote that. also beware. you may need to set the Search Results (top left?) to show data as Memberships rather than Contacts
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-28T15:09:54.603Z
Answers.Text: Got it, thank you very much for your help.
Answers.UserDisplayName: NHPHA Executive Assistant
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-26T21:25:17.700Z
Answers.LastActivityDate: 2021-04-12T23:12:12.317Z
Answers.LastEditDate: 2021-04-12T23:12:12.317Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Good morning,</p>
  
  <p>I'm a program assistant at the NH Public Health Association, and we need to determine the following data:</p>
  
  <ol>
  <li><p>Number of current (as of a certain date within a year; e.g., February 26, 2019) members of NHPHA</p></li>
  <li><p>Number of members at any time during a specific year (e.g., 2019)</p></li>
  </ol>
  
  <p>We have tried to use the Reports function to determine these data, without success. Can anyone explain how to do this? Please let us know if there are specific filters we should be using. We appreciate any help anyone could give us. Thanks in advance!</p>
  
  <p>Sincerely,
  Jess </p>
  
Tags: <civimember>
Title: Help needed: Need to run reports to find information on number of members during a specific year
ThreadText: # Help needed: Need to run reports to find information on number of members during a specific year
  
  (Asked by: username_0 on 2019-02-26)
  
  Good morning,
  
  I'm a program username_0 at the NH Public Health Association, and we need to determine the following data:
  
  1. Number of current (as of a certain date within a year; e.g., February 26, 2019) members of username_0
  2. Number of members at any time during a specific year (e.g., 2019)
  
  We have tried to use the Reports function to determine these data, without success. Can anyone explain how to do this? Please let us know if there are specific filters we should be using. We appreciate any help anyone could give us. Thanks in advance!
  
  Sincerely,
  Jess
  
  **Tags:** civimember
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-02-26. Score: 1
  
  UPDATE: also try the [nz.co.username_1.historicmembershipdata extension](https://github.com/fuzionnz/nz.co.username_1.historicmembershipdata)
  
  Try the [Membership Churn](https://civicrm.org/extensions/membership-churn-reports) extension otherwise
  
  1/ I think you can get via
  
  Adv Search
  
  Set Start Date to < Feb 26 2019
  
  Set End Date to > Feb 26 2019
  
  2/ might be a bit trickier but I suggest using Search Builder and something like
  
  Set Start Date > Jan 1 2019 to Dec 31 2019
  
  OR
  
  Set End Date to > Jan 1 2019 to Dec 31 2019
  
  EDIT: you may need to also exclude Memberships that are 'old' ones which you may be able to do via Memb Status
  
  > **Comments:**
  > **username_0**: Follow-up question, Pete: Using the search filters, how do I search for specifically "Set Start Date to < Feb 26 2019" or "Set End Date to > Feb 26 2019"? I mean, what exactly do I put in the "Choose Date Range" fields?  
  > **username_1**: for the first example in the Start Date you would leave the 'from' field blank, and put the desired date in the To. so it says, show me all results that started before date x. then in the End date field you say 'show me all results where the End Date is 'after'' hence you put the date in the 'from' and nothing in the 'to'.  
  > **username_1**: hoping my logic is hte right way round. not looking at Adv Search as i wrote that. also beware. you may need to set the Search Results (top left?) to show data as Memberships rather than Contacts  
  > **username_0**: Got it, thank you very much for your help.  
  
  ---
  
  