When querying on attributes, the end date field does not include the options for searching for blanks.

When querying on attributes, the end date field does not include the options for searching for blanks.  However, the Start date on or before option does.
Add a criteria of 'or end date is blank' to the query.

Steps to Duplicate

1. Log in to BBCRM.
2. Go to the Analysis functional area.
3. Click information library.
4. Click the Add an ad-hoc query  button.
5. Select any attribute to query on.
6. Select the End Date field.
7. Select on or after from the drop down.
8. Select a date.
9. Click okay.
10. Note that there isn't an option to include blanks.

Environment

 Blackbaud CRM
 4.0
 4.0.173

Was this article helpful?