Export contains incorrect solicitor assignments when Start Date and/or End Date filters are used

In a Constituent Export, using Start Date and/or End Date criteria when exporting Assigned Solicitor information to filter on Date from and Date to on the assigned solicitor relationship, The Raiser's Edge incorrectly outputs assigned solicitors that do not meet the criteria.
The start date and end date in Raiser's Edge Export define a period of time. In the example provided, when including an end date in the export field criteria the results will include any Assigned Solicitor that have a relationship end date on or before the date included. Records that are still considered active Assigned Solicitors (i.e. the Date To field is blank on the relationship record) will not be included in the Export results.

Steps to Duplicate

1. Select Export module
2. Click New Export
3. Type = Excel, format = Excel
4. Include > One record > Julie Bach (from RE Sample database)
5. Select Output tab
6. Relationships / Assigned Solicitors / Name
7. Number to export = 5
8. End Date = select today's date
9. Click OK
10. Select Date From and Date To
11. File / Preview Export File Layout
12. Note that Cynthia Miller is incorrectly listed with Date To date of 05/17/2013

Environment

 RE 7.94.6116.0

Was this article helpful?