The ‘[Recognition Program]\Years consecutive’ field in a Constituent ad-hoc query does not calculate correctly.

Constituent recognition programs are used to track a donor’s giving, and recognize them for their contributions when they have given a set amount within a defined timeframe. At times it is necessary to determine how many consecutive years a constituent met the requirements of a recognition program.  The ‘[Name of Recognition Program]\Years consecutive’ query field may be used to determine this value. CRM users may notice that the value returned by the query field is not correct.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.94.1524
 2.94.1524, patch 107 ; 3.0.516, Service Pack 10 ; 4.0.138, patch 2

Was this article helpful?