Date selection problem with ADO recordset

[tmkraynak]

I have a report that uses an ADO recordset. Date selection for blank dates does not seem to work correctly. I want to exclude records with blank dates. If I do not use any date selection, records display (there are records with dates, and there are records with blank dates). However if I select for a blank date ( < 1/1/1 , or =0/0/0) then ALL records are filtered from the report, including the non-blank ones. What is wrong ?
Any suggestions appreciated.

 

[Naith]

A null value is different from a value of 0. That is to say, if you ask the report to focus on values = 0, or less than 1, null values won't be returned.

You need to specify where the date is null to the report.