detecting a null date

[tedpottel]

Hi,


I am trying to create a querry that will disply all the records where the date field has not ben set.
For the Criteria I have
=null.

The result is a empty set, whet there are 10 records that have a null value for the date fields.

How can I creat a listing of all the fields where the date has not whet been filled out?

-Ted

[pbaldy]

Nothing is ever equal to Null. Try a criteria of:

Is Null

[tedpottel]

Nothing is ever equal to Null. Try a criteria of:

Is Null

Thank you,
-Ted

[pbaldy]

No problem, and welcome to the site by the way!