Answers.Body: <p>There is an extension that provides a report to do this <a href="https://github.com/MegaphoneJon/org.cpehn.subscriptionhistory" rel="nofollow noreferrer">https://github.com/MegaphoneJon/org.cpehn.subscriptionhistory</a> that does this.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-30T16:13:29.930Z
Answers.Text: also good. thanks!
Answers.UserDisplayName: Guillaume Sorel
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-31T13:34:44.853Z
Answers.Text: But the other option is better as it displays the whole history, not just one value. And I've just found that when I add/remove/add/remove, that it doesn't show the latest status (added) if you don't filter status but does show removed if you filter by that status. So I have voted for the other option!
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-30T14:40:15.093Z
Answers.LastActivityDate: 2019-10-30T14:40:15.093Z
Answers.UserDisplayName: Mick Kahn
Answers.Body: <p>Under custom searches there is a search you can use for date range of subscription to a group. You could then create a smart group from the results if needed. Its called "Search Group Subscription by Date Range"</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-30T14:41:30.580Z
Answers.Text: I don't think this is a custom report in the standard distribution. I can't see it.
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-30T14:59:11.940Z
Answers.Text: Thanks Parvez, this was exactly was I was looking for.
Answers.UserDisplayName: Guillaume Sorel
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-31T13:27:04.203Z
Answers.Text: Further to my earlier comment, you need to have the GDPR extension installed to get this option, which is why I couldn't find it. But it looks better than my suggestion below as it shows all the history not just the latest value.
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-02T07:21:59.957Z
Answers.Text: Thanks Mick, we install it as part of our deployments, thats why I missed that its a _custom_ custom search
Answers.UserDisplayName: Parvez Saleh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-30T13:10:11.570Z
Answers.LastActivityDate: 2019-10-30T13:10:11.570Z
Answers.UserDisplayName: Parvez Saleh
Body: <p>I need to have a report that shows members according to their date of being part of a chosen group. I can select by group but not by date of being in this group. </p>
  
  <p>Is this possible?</p>
  
  <p>(I have a special process for membership that includes a control step to fully validate the membership. We have to check some documents so there can be a delay between "civicrm membership" and our membership.)</p>
  
  <p>thanks for your ideas</p>
  
  <p>G</p>
  
Tags: <civireport>
Title: how to create a report based on date subscription to a group?
ThreadText: # how to create a report based on date subscription to a group?
  
  (Asked by: username_0 on 2019-10-30)
  
  I need to have a report that shows members according to their date of being part of a chosen group. I can select by group but not by date of being in this group.
  
  Is this possible?
  
  (I have a special process for membership that includes a control step to fully validate the membership. We have to check some documents so there can be a delay between "civicrm membership" and our membership.)
  
  thanks for your ideas
  
  G
  
  **Tags:** civireport
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2019-10-30. Score: 3 | Accepted answer
  
  Under custom searches there is a search you can use for date range of subscription to a group. You could then create a smart group from the results if needed. Its called "Search Group Subscription by Date Range"
  
  > **Comments:**
  > **username_1**: I don't think this is a custom report in the standard distribution. I can't see it.  
  > **username_0**: Thanks username_2, this was exactly was I was looking for.  
  > **username_1**: Further to my earlier comment, you need to have the GDPR extension installed to get this option, which is why I couldn't find it. But it looks better than my suggestion below as it shows all the history not just the latest value.  
  > **username_2**: Thanks username_1, we install it as part of our deployments, thats why I missed that its a _custom_ custom search  
  
  ---
  
  ### Answer by username_1 on 2019-10-30. Score: 2
  
  There is an extension that provides a report to do this <https://github.com/MegaphoneJon/org.cpehn.subscriptionhistory> that does this.
  
  > **Comments:**
  > **username_0**: also good. thanks!  
  > **username_1**: But the other option is better as it displays the whole history, not just one value. And I've just found that when I add/remove/add/remove, that it doesn't show the latest status (added) if you don't filter status but does show removed if you filter by that status. So I have voted for the other option!  
  
  ---
  
  