finding empty date fields

[steiny]

How do you do a search or limit records to empty date fields (ie date paid) It seems the usual way of using the * or = in a field search doesn't work.

[DanBrill]

Do a find for the range 1/1/0001...12/31/4000 with the omit option checked. This is the full range of dates that FM recognizes. By omitting them you'll find the empty values.

Dan

[-Queue-]

Set Field [datepaid, "="] should work in version 7. It doesn't seem to require Insert Calculated Result, as previous versions do.