Answers.Body: <p>The modern solution to this would be SearchKit.</p>
  <p>Search for Contacts, and join to Contributions.  Group by Contact ID. Add the contribution date in <em>Select Fields</em>, and change it to <strong>Max</strong> so we see the most recent contribution date for each contact.</p>
  <p>Now, on the <em>Filter</em> tab, you can search for contacts with a max contribution date before a certain date.  This only captures people who have donated before.  If you need to also capture people who have never donated, you need to also include people whose max contribution date is empty.</p>
  <p>You can <a href="https://mysite.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22,%22MAX(Contact_Contribution_contact_id_01.receive_date)%20AS%20MAX_Contact_Contribution_contact_id_01_receive_date%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22id%22%5D,%22join%22:%5B%5B%22Contribution%20AS%20Contact_Contribution_contact_id_01%22,%22LEFT%22,%5B%22id%22,%22%3D%22,%22Contact_Contribution_contact_id_01.contact_id%22%5D%5D%5D,%22having%22:%5B%5B%22OR%22,%5B%5B%22MAX_Contact_Contribution_contact_id_01_receive_date%22,%22IS%20EMPTY%22%5D,%5B%22MAX_Contact_Contribution_contact_id_01_receive_date%22,%22%3C%22,%222023-12-31%22%5D%5D%5D%5D%7D" rel="nofollow noreferrer">click this URL</a> and change <code>https://mysite.org</code> to your own site to load this query, or you can use the screenshots below.</p>
  <p><a href="https://i.sstatic.net/XCWY7Dcg.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/XCWY7Dcg.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.sstatic.net/pzXsghPf.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/pzXsghPf.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.sstatic.net/kEpZquLb.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/kEpZquLb.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-14T16:20:26.323Z
Answers.LastActivityDate: 2024-05-14T16:20:26.323Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>You can make a group (e.g 'Donations but not in last 2 years') and add everyone who has ever donated, then do a second search for people who have donated in the last two years. Then remove these contacts from the group (select them all and click on Group - remove contacts).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-14T14:44:03.030Z
Answers.LastActivityDate: 2024-05-14T14:44:03.030Z
Answers.UserDisplayName: Kathryn McNeill
Answers.Body: <p>You can use <a href="https://civicrm.org/extensions/civirules" rel="nofollow noreferrer">CiviRules</a> extension to get that is required. You can setup triggers, conditions and actions using this extension.</p>
  
  <p>A detailed documentation has been compiled by them which can be found <a href="https://docs.civicrm.org/civirules/en/latest/" rel="nofollow noreferrer">here</a>.</p>
  
  <p>Hope this helps.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-15T18:10:02.937Z
Answers.LastActivityDate: 2018-01-15T18:10:02.937Z
Answers.UserDisplayName: Hassan Farooq
Answers.Body: <p>I would use the CiviRules extension to achieve this. With this extension you can check if contacts in a certain group have not donated for a period of time for example.</p>
  
  <p>You can find the extension here: <a href="https://civicrm.org/extensions/civirules" rel="nofollow noreferrer">https://civicrm.org/extensions/civirules</a> (or in your extension list)</p>
  
  <p>Documentation on using this extension can be found here:<a href="https://docs.civicrm.org/civirules/en/latest/" rel="nofollow noreferrer">https://docs.civicrm.org/civirules/en/latest/</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-15T06:59:55.713Z
Answers.LastActivityDate: 2018-01-15T06:59:55.713Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>Hello CiviCRM community,</p>
  
  <p>I've been trying to wrap my head around this and can't seem to figure it out.</p>
  
  <p>I'm looking to get list of contacts that have not donated within a certain amount of time to target them to donate.</p>
  
  <p>Any ideas on how to run this report?</p>
  
Tags: <civicontribute><contacts><civireport><contributions>
Title: How to get a list contacts that have not donated within a certain amount of time?
ThreadText: # How to get a list contacts that have not donated within a certain amount of time?
  
  (Asked by: username_0 on 2018-01-14)
  
  Hello CiviCRM community,
  
  I've been trying to wrap my head around this and can't seem to figure it out.
  
  I'm looking to get list of contacts that have not donated within a certain amount of time to target them to donate.
  
  Any ideas on how to run this report?
  
  **Tags:** civicontribute, contacts, civireport, contributions
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_4 on 2018-01-15. Score: 2 | Accepted answer
  
  I would use the CiviRules extension to achieve this. With this extension you can check if contacts in a certain group have not donated for a period of time for example.
  
  You can find the extension here: <https://civicrm.org/extensions/civirules> (or in your extension list)
  
  Documentation on using this extension can be found here:<https://docs.civicrm.org/civirules/en/latest/>
  
  
  ---
  
  ### Answer by username_1 on 2024-05-14. Score: 3
  
  The modern solution to this would be SearchKit.
  
  Search for Contacts, and join to Contributions. Group by Contact ID. Add the contribution date in *Select Fields*, and change it to **Max** so we see the most recent contribution date for each contact.
  
  Now, on the *Filter* tab, you can search for contacts with a max contribution date before a certain date. This only captures people who have donated before. If you need to also capture people who have never donated, you need to also include people whose max contribution date is empty.
  
  You can [click this URL](https://mysite.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22,%22MAX(Contact_Contribution_contact_id_01.receive_date)%20AS%20MAX_Contact_Contribution_contact_id_01_receive_date%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22id%22%5D,%22join%22:%5B%5B%22Contribution%20AS%20Contact_Contribution_contact_id_01%22,%22LEFT%22,%5B%22id%22,%22%3D%22,%22Contact_Contribution_contact_id_01.contact_id%22%5D%5D%5D,%22having%22:%5B%5B%22OR%22,%5B%5B%22MAX_Contact_Contribution_contact_id_01_receive_date%22,%22IS%20EMPTY%22%5D,%5B%22MAX_Contact_Contribution_contact_id_01_receive_date%22,%22%3C%22,%222023-12-31%22%5D%5D%5D%5D%7D) and change `https://mysite.org` to your own site to load this query, or you can use the screenshots below.
  
  [![enter image description here](https://i.sstatic.net/XCWY7Dcg.png)](https://i.sstatic.net/XCWY7Dcg.png)
  
  [![enter image description here](https://i.sstatic.net/pzXsghPf.png)](https://i.sstatic.net/pzXsghPf.png)
  
  [![enter image description here](https://i.sstatic.net/kEpZquLb.png)](https://i.sstatic.net/kEpZquLb.png)
  
  
  ---
  
  ### Answer by username_2 on 2024-05-14. Score: 2
  
  You can make a group (e.g 'Donations but not in last 2 years') and add everyone who has ever donated, then do a second search for people who have donated in the last two years. Then remove these contacts from the group (select them all and click on Group - remove contacts).
  
  
  ---
  
  ### Answer by username_3 on 2018-01-15. Score: 0
  
  You can use [CiviRules](https://civicrm.org/extensions/civirules) extension to get that is required. You can setup triggers, conditions and actions using this extension.
  
  A detailed documentation has been compiled by them which can be found [here](https://docs.civicrm.org/civirules/en/latest/).
  
  Hope this helps.
  
  
  ---
  
  