Data Selection on Null Date or Time
I've created a new report and I want to set data selection where a date field is Null. I've run a SQL query to view the data prior to running the report and I'm getting over 2000 rows where the date is null. When I ran the report, it only returned 2 rows. The only item in my data selection is the date parameter. The data dictionary data type is Date. If I look at the data in data browser I can the rows where the date appears to be null.
I have a time field that I also tried to use. I set the data selection where the time is equal to null or zero. Again, I only got the 2 lines instead of 2000+.