Method 1
First, we'll create a query that finds all donations
  1. Click Queries
  2. Click Manage Queries
  3. Select the category where you would like to store this query
  4. Select New Query under the Tasks menu
  5. Name the query All Donations
  6. Set the Starting Query to Base/All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Under Criteria Matching select Match Each Criteria
  9. Select Commonly Used Fields from the Browse Fields drop down menu and click on Individual Transaction Received
  10. Fill in Greater Than or Equal to .01
  11. Click Save and View Queries
Then, we'll create a query to find the first transactions
  1. Select New Query under the Tasks menu
  2. Name the query First Donations
  3. Set the Starting Query to the All Donations query that we created above
  4. Set the Data Return Type to Journal Entries
  5. Under Criteria Matching select Match Each Criteria
  6. Select Journal from the Browse Fields drop down menu and click on First/Last Entry
  7. Select First from the drop down menu and fill in 1 in the text box
  8. Click Save and View Queries
Last, we'll create a query that looks for first transactions within the specific date range
  1. Select New Query under the Tasks menu
  2. Name the query First Donations from [insert dates]
  3. Set the Starting Query to the First Donations query that we created above
  4. Set the Data Return Type to Journal Entries
  5. Under Criteria Matching select Match Each Criteria
  6. Select Commonly Used Fields from the Browse Fields drop down menu and click on Journal Entry Date
  7. Fill in the Start and End Dates for the date range you'd like to search
  8. Click Save and View Queries
Method 2
First, we'll create a query to find all donations within your given date range
  1. Click Queries
  2. Click Manage Queries
  3. Select the category where you would like to store this query
  4. Select New Query under the Tasks menu
  5. Name the query All donations from [insert dates]
  6. Set the Starting Query to Base/All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Under Criteria Matching select Match Each Criteria
  9. Select Commonly Used Fields from the Browse Fields drop down menu and click on Journal Entry Date
  10. Fill in the date range that you'd like to search
  11. Select Commonly Used Fields from the Browse Fields drop down menu and click on Individual Transaction Received
  12. Fill in Greater Than or Equal to .01
  13. Click Save and View Queries
Then, we'll create another query to find donors who have given prior to the date range
  1. Select New Query under the Tasks menu
  2. Name the query Donors who gave prior to [insert date]
  3. Set the Starting Query to Base/All Constituents
  4. Set the Data Return Type to Accounts
  5. Under Criteria Matching select Match Each Criteria
  6. Select Commonly Used Fields from the Browse Fields drop down menu and click on Journal Entry Date
  7. Set the End Date to one day before the Start Date in the query we created above (for example, if the Start Date in the query above was July 1, 2016, then the End Date on this query would be June 30, 2016)
  8. Select Commonly Used Fields from the Browse Fields drop down menu and click on Individual Transaction Received
  9. Fill in Greater Than or Equal to .01
  10. Click Save and View Queries
Last, we'll create a compound query to find the new donors from this date range
  1. Select New Compound Query under the tasks menu
  2. Name the query 
  3. Set the Data Return Type to Journal Entries
  4. Under Combine the Queries select Subtract
  5. For Query 1 choose the All Donations from [insert dates] query that we created first
  6. For Query 2 choose Donors who gave prior to [insert dates] query that we created second
  7. Click Save and Preview