Answers.Body: <p>You will need to do two searches.</p>
  
  <p>First, use the <strong>Recurring Contributions Report</strong> (/civicrm/report/contribute/recur).</p>
  
  <ol>
  <li>Filter by "Start Date".</li>
  <li>Optionally, filter by Financial Type or any other criteria you want (for example, to exclude membership-related contributions).</li>
  <li>Refresh the results.</li>
  <li>Add the found contacts to a "People to Thank" group.</li>
  </ol>
  
  <p>Then, do an <strong>Advanced Search</strong>.</p>
  
  <ol>
  <li>Open the Contributions accordion tab.</li>
  <li>Filter by "Date Received".</li>
  <li>Check "No" next to "Contribution is Recurring?".</li>
  <li>Optionally, filter by Financial Type or any other criteria you want (for example, to exclude membership-related contributions).</li>
  <li>Run the search.</li>
  <li>Add the found contacts to your "People to Thank" group.</li>
  </ol>
  
  <p>Now, your "People to Thank" group contains everyone who started a recurring contribution <em>plus</em> everyone who made a one-time donation in the specified timeframe.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-22T22:13:07.183Z
Answers.LastActivityDate: 2019-08-22T22:13:07.183Z
Answers.UserDisplayName: Noah Miller
Answers.Body: <p>Yes, there is no such field in contribution table that holds when a contribution record was actually created. However an activity is created when a contribution is recorded with status completed. If contribution is created with pending status and updated later after day or 2 then it is very difficult to track via Activity.</p>
  
  <p>I have an <a href="https://github.com/pradpnayak/org.civicrm.submitteddonotionreport" rel="noreferrer">extension</a> that uses activity to get created date and display on a Civi Contribution Detail report. </p>
  
  <p>The alternate way of doing this would be create a date custom field for contribution, auto populate the field with now() using buildform or post hook.</p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-14T11:08:32.440Z
Answers.LastActivityDate: 2019-08-14T11:08:32.440Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I want to send thank you letters and gift aid forms to everyone who 'created' a contribution donation (not membership contribution) within a period of a few months, a one off or recurring donation with us. I can only seem to get results with received date, which might be fine for the one-off donations, but not for recurring ones, as we receive them every month. It seems that neither the Search builder nor Find Contributions can create a report with the 'created date'. Any thoughts? Am I missing something, or is this not available? </p>
  
Tags: <civicontribute><search>
Title: Struggling: Search report for donations by creation date not receive date
ThreadText: # Struggling: Search report for donations by creation date not receive date
  
  (Asked by: username_0 on 2019-08-14)
  
  I want to send thank you letters and gift aid forms to everyone who 'created' a contribution donation (not membership contribution) within a period of a few months, a one off or recurring donation with us. I can only seem to get results with received date, which might be fine for the one-off donations, but not for recurring ones, as we receive them every month. It seems that neither the Search builder nor Find Contributions can create a report with the 'created date'. Any thoughts? Am I missing something, or is this not available?
  
  **Tags:** civicontribute, search
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-08-22. Score: 2 | Accepted answer
  
  You will need to do two searches.
  
  First, use the **Recurring Contributions Report** (/civicrm/report/contribute/recur).
  
  1. Filter by "Start Date".
  2. Optionally, filter by Financial Type or any other criteria you want (for example, to exclude membership-related contributions).
  3. Refresh the results.
  4. Add the found contacts to a "People to Thank" group.
  
  Then, do an **Advanced Search**.
  
  1. Open the Contributions accordion tab.
  2. Filter by "Date Received".
  3. Check "No" next to "Contribution is Recurring?".
  4. Optionally, filter by Financial Type or any other criteria you want (for example, to exclude membership-related contributions).
  5. Run the search.
  6. Add the found contacts to your "People to Thank" group.
  
  Now, your "People to Thank" group contains everyone who started a recurring contribution *plus* everyone who made a one-time donation in the specified timeframe.
  
  
  ---
  
  ### Answer by username_2 on 2019-08-14. Score: 6
  
  Yes, there is no such field in contribution table that holds when a contribution record was actually created. However an activity is created when a contribution is recorded with status completed. If contribution is created with pending status and updated later after day or 2 then it is very difficult to track via Activity.
  
  I have an [extension](https://github.com/pradpnayak/org.civicrm.submitteddonotionreport) that uses activity to get created date and display on a Civi Contribution Detail report.
  
  The alternate way of doing this would be create a date custom field for contribution, auto populate the field with now() using buildform or post hook.
  
  HTH
  
  Pradeep
  
  
  ---
  
  