Answers.Body: <p>I have an extension that provides a custom report <a href="https://github.com/MegaphoneJon/org.cpehn.subscriptionhistory" rel="nofollow noreferrer">Subscription History</a> that does this.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-22T16:27:53.580Z
Answers.LastActivityDate: 2018-05-22T16:27:53.580Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>I'm not sure if this functionality exists from the UI or API. I think it's not. </p>
  
  <p>A quick recall says that this info is being stored in <code>civicrm_subscription_history</code> table where <code>contact_id</code>, <code>group_id</code>, <code>status(Added or Removed)</code> and <code>date</code>(the one when the action was triggered) can be viewed.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-10T07:19:47.710Z
Answers.LastActivityDate: 2017-01-10T08:58:36.383Z
Answers.LastEditDate: 2017-01-10T08:58:36.383Z
Answers.UserDisplayName: jitendra - fuzion
Answers.Body: <p>For info, the <a href="https://civicrm.org/extensions/gdpr" rel="nofollow noreferrer">GDPR extension</a> (first released March 2018) includes a "Search Group Subscription by Date Range" custom search i.e. you can select a group, a group status and importantly a date criteria.</p>
  
  <p>If the rest of the GDPR extension functionality isn't needed, and you're keen and able, the relevant sections of code could be used as a basis to make your own custom search extension.</p>
  
  <p>Or adding to jitendra's answer, output the contact IDs with something like this database query:</p>
  
  <pre><code>SELECT * FROM civicrm_subscription_history WHERE group_id = ? AND status = "Removed" AND date &gt; "????-??-?? ??:??:??";
  </code></pre>
  
  <p>As required, these could then be output as CSV e.g. using phpMyAdmin and then added to a group(s) via Import Contacts.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-22T12:00:19.667Z
Answers.LastActivityDate: 2018-05-22T12:00:19.667Z
Answers.UserDisplayName: oskylark
Body: <p>I need to rebuild some groups where all the members were removed by the link between CiviCRM and Mailchimp. I have found the ability to list all members of a group who have ever been removed from that group, but I also need to be able to filter this by the date they were removed. Is there any way to search for members of a group who were removed on a specific date?</p>
  
Tags: <groups><search>
Title: Search by date removed from group
ThreadText: # Search by date removed from group
  
  (Asked by: username_0 on 2017-01-09)
  
  I need to rebuild some groups where all the members were removed by the link between CiviCRM and Mailchimp. I have found the ability to list all members of a group who have ever been removed from that group, but I also need to be able to filter this by the date they were removed. Is there any way to search for members of a group who were removed on a specific date?
  
  **Tags:** groups, search
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2018-05-22. Score: 3
  
  I have an extension that provides a custom report [Subscription History](https://github.com/MegaphoneJon/org.cpehn.subscriptionhistory) that does this.
  
  
  ---
  
  ### Answer by username_2 on 2017-01-10. Score: 3
  
  I'm not sure if this functionality exists from the UI or API. I think it's not.
  
  A quick recall says that this info is being stored in `civicrm_subscription_history` table where `contact_id`, `group_id`, `status(Added or Removed)` and `date`(the one when the action was triggered) can be viewed.
  
  
  ---
  
  ### Answer by username_3 on 2018-05-22. Score: 2
  
  For info, the [GDPR extension](https://civicrm.org/extensions/gdpr) (first released March 2018) includes a "Search Group Subscription by Date Range" custom search i.e. you can select a group, a group status and importantly a date criteria.
  
  If the rest of the GDPR extension functionality isn't needed, and you're keen and able, the relevant sections of code could be used as a basis to make your own custom search extension.
  
  Or adding to username_2's answer, output the contact IDs with something like this database query:
  
  ```
  SELECT * FROM civicrm_subscription_history WHERE group_id = ? AND status = "Removed" AND date > "????-??-?? ??:??:??";
  
  ```
  
  As required, these could then be output as CSV e.g. using phpMyAdmin and then added to a group(s) via Import Contacts.
  
  
  ---
  
  