I am trying to run a report where it will pull all date fields that are blank. I have tried the field = null and it has not worked.
Printable View
I am trying to run a report where it will pull all date fields that are blank. I have tried the field = null and it has not worked.
Welcome to CodeGuru forums!
In CR ide, select menu / File / Report Options
It will display a properties page
Uncheck : "Convert Database NULL Values to Default"
Add a Record Selection Formula
It will display all the records that has a null value in that fieldCode:IsNull ({TableName.DateFieldName})
(change the table & field names to the real ones)
OR
In CR ide, select menu / File / Report Options
It will display a properties page
Check : "Convert Database NULL Values to Default"
Add a Record Selection Formula
It will display all the records that had a null value in that field before CR converted them internally to a zero dateCode:DateValue ({TableName.DateFieldName}) = DateValue(0,0,0)
(change the table & field names to the real ones)