After the transition to MySQL8 in Apricot, dates in the system are no longer stored as null values, but as 00-00-0000. Query filters in Apricot Results Reporting (ARR) do not consider this a null date, but the variables and filters created within the report do.
​
As a result, using the expression "[Date Field] Is Null" in query filters no longer work as expected. Continue reading below to learn how to effectively filter report data for records that have a blank or null value for a date field.

Open the Query Panel by clicking the graph-and-gear icon under Data at the top of the report.

Then, drag the date field you want to filter the report by into the Query Filters section. In the first dropdown field, select 'Less than' and type "1/1/1900" in the next text field. This will guarantee the report filters not only for values of "00-00-0000" but any other values that might be considered blank or null as well.
​

You can open any previously existing reports and review their query filters to replace "Is Null" filters with this recommended expression as well. Some reports may have multiple queries, so be sure to click into each one.

Once the query filters are set up correctly, the report can be built as normal. Despite the value discrepancy, outside of the query itself, Results is able to discern that these "00-00-0000" values are null values, and formulas like "IsNull()" will continue to work as expected.