Why is my query returning incorrect results when I use the Classification Exists (by date) function field?

As of July 12, 2021, this "Learn Veracross" site has been deprecated.  It will remain live at least through December 23, 2021, but will no longer be updated. Q&A articles are only visible to authenticated users in the Veracross Community; please speak with your implementation or account manager for additional information.

The system looks at the high level date range when returning results for this function field. If someone has an actual Classification Start/End Date and the School Year Start/End Date fields are both populated, the system uses the School Year Start/End date instead of the date range (or vice versa if the date range falls outside the school year).