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

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).