AND Prospect > Ratings > Date between [1/1/##] and [12/31/##]
NOTE: This may not work in certain situations, such as when a constituent's most recent ratings were in one year, but you have other ratings from later years.
To resolve this, create additional queries (one for each year) and merge them.
- In the merge, use the query for the previous year's ratings as the Primary Query.
- Use the query with the ratings from the current year as the Secondary Query.
- Select SUB as the merge operator.