Hello,
I haven't been able to find a forum posting for this issue: I'm working on an extraction where I need to find out what donors give frequently. I built a criteria set that used my different date ranges of fiscal years all together, the contribution date ranges for Fiscal Years 2006, 2007, 2008, 2009, 2010, & 2011, so that it would consider it an "AND," not an "OR" (per the instructions of the documentation for the Criteria for Lists and Extractions) between the different date ranges.
This results in zero constituents being pulled. I decided to take away some of the date ranges, since it may have been too restrictive--maybe there really isn't one person who gave all 6 years? I troubleshooted a bit on my own, taking away all the date ranges except one works fine, I end up with the list of constituents who gave during that fiscal year. I even tried just doing two consecutive years, 2010 and 2011, which I know have some overlapping donors...but again, nothing. When I pulled for just one year, for 2010, I once more had a nice tidy list of constituents.
Does anyone know how to do this? I don't even need the constituents for every fiscal year, just the frequent ones, something that could tell me the donors that gave 3 or 4 out of the last 5 years is great.
greatly appreciated,
Ruthie Hubka
The issues is that a single contribution is not going to be in all Fiscal years you have listed.
We have created custom list elements that will make this easier. However this would not be easy to explain here.
You can try to contact your IT staff to see if they can puting this in a manualy edited query that produces the results you are trying to produce.