Answers.Body: <p>If you are using Drupal you could do this by sending out a checksum link to the webform, and in the webform settings have an Activity that will set to Completed when they submit the form. Then you can simply check in CiviCRM which contacts have an Activity that is Scheduled v Completed.</p>
  
  <p>Otherwise, you could set up a custom CiviCRM profile and send out a checksum link to that profile, and in the Adv Settings of the Profile add anyone who submits the Profile to a specific Group. And then do as Jon suggests above.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-27T20:14:17.313Z
Answers.LastActivityDate: 2015-04-27T20:14:17.313Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>The process is slightly roundabout:</p>
  
  <ul>
  <li>Create a smart group that captures all contacts called "All Contacts".</li>
  <li>Create a second smart group consisting of people who have the activity type "Confirm Contact Details".</li>
  <li>Use the "Include/Exclude Search" (<strong>Search menu > Custom Searches</strong>) to include the first smart group and exclude the second smart group.</li>
  </ul>
  
  <p>Once you've done this, you can save it as a smart group for one-step searches moving forward.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-01T03:29:31.417Z
Answers.Text: +1. This feature of include/exclude is awesome. Did exactly what I needed.
Answers.UserDisplayName: Adam
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-27T19:59:08.227Z
Answers.LastActivityDate: 2015-04-27T19:59:08.227Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I'd like to be able to track which contacts details have been confirmed every so often. Every so often, we'll go through our contacts and confirm that their address, email address, phone numbers, etc are still accurate.</p>
  
  <p>I'm thinking about using an activity type to accomplish this. I'd call it "Confirm contact details" or something and when I confirm that a contact's information is correct, I could create an activity on that contact. This would have let me know when the contact's information was last checked, and by who.</p>
  
  <p>This would be ideal, except that I can't figure out how to generate a report showing only those contacts whose information <em>hasn't</em> been confirmed in so many months.</p>
  
  <p>Is there a way to find contacts that do not have an activity of type "Confirm contact details" in the last Y months?</p>
  
Tags: <contacts><activities>
Title: How can I show contacts that DO NOT have an activity of type X in last Y months?
ThreadText: # How can I show contacts that DO NOT have an activity of type X in last Y months?
  
  (Asked by: username_0 on 2015-04-27)
  
  I'd like to be able to track which contacts details have been confirmed every so often. Every so often, we'll go through our contacts and confirm that their address, email address, phone numbers, etc are still accurate.
  
  I'm thinking about using an activity type to accomplish this. I'd call it "Confirm contact details" or something and when I confirm that a contact's information is correct, I could create an activity on that contact. This would have let me know when the contact's information was last checked, and by who.
  
  This would be ideal, except that I can't figure out how to generate a report showing only those contacts whose information *hasn't* been confirmed in so many months.
  
  Is there a way to find contacts that do not have an activity of type "Confirm contact details" in the last Y months?
  
  **Tags:** contacts, activities
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2015-04-27. Score: 11 | Accepted answer
  
  The process is slightly roundabout:
  
  * Create a smart group that captures all contacts called "All Contacts".
  * Create a second smart group consisting of people who have the activity type "Confirm Contact Details".
  * Use the "Include/Exclude Search" (**Search menu > Custom Searches**) to include the first smart group and exclude the second smart group.
  
  Once you've done this, you can save it as a smart group for one-step searches moving forward.
  
  > **Comments:**
  > **username_3**: +1. This feature of include/exclude is awesome. Did exactly what I needed.  
  
  ---
  
  ### Answer by username_1 on 2015-04-27. Score: 1
  
  If you are using Drupal you could do this by sending out a checksum link to the webform, and in the webform settings have an Activity that will set to Completed when they submit the form. Then you can simply check in CiviCRM which contacts have an Activity that is Scheduled v Completed.
  
  Otherwise, you could set up a custom CiviCRM profile and send out a checksum link to that profile, and in the Adv Settings of the Profile add anyone who submits the Profile to a specific Group. And then do as Jon suggests above.
  
  
  ---
  
  