Help with query

[fin...@northvalleysymphony.org]

Hi, I hope someone can help.
I have a Google sheets that has a list of donors and the dates of donations and their contact information.  Some donors donate multiple times per year.  I am trying to use query to generate a list of people who donated in the current month one year ago, but EXCLUDE any names that may have donated more recently.   We are trying to generate a list of people to contact to see it they would be willing to donate again but don't want to bother them if they have already donated more recently than one year.

Any ideas on how to do this would be appreciated.
Steve

[Steven Thomasson]

This is what I have so far:
=query('Donors & Sponsors'!A4:H, "select A, sum(F) where A <> '' and date '" & text(B1, "yyyy-mm-dd") & "' <= toDate(C) and toDate(C) <= date '" & text(C1, "yyyy-mm-dd") & "' group by A label A 'Name', sum(F) 'Total contribution' ",1)

This gives me a list of donors that gave a year ago but does not exclude any people have donated more recently.  I cannot figure out how to do that.  Someone please help.

[Daniel LaLiberte]

Hi Steve,

You should probably ask this question on a forum that is more specific to Google Sheets, since the Google Charts queries are actually interpreted by the Sheets side.  Try: https://groups.google.com/forum/#!forum/google-spreadsheets-api

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/e749fc79-9c3a-46a4-ae2a-5b53e40d9b77%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA