I figured out the first question. I saw this in the PDF manual, but misunderstood it as trying to match 0000-00-00 as a date:
Quote:
|
If you specify that the Search Text is Text (not a Lookup/Search Name), and you leave the field empty, it will be treated as an empty string (i.e., “”) for text, a 0 for integers, 0.00 for floats, and “0000-00-00” for dates.
|
Searching a blank value with = or != worked.
