Testing for empty date field

[NeeNee]

I have a table with a start and end date field. When the record is first created, a start date is entered but the end date is left empty.
I have been trying to query for the empty end date using the null, spaces and empty string, but I keep getting a data type mismatch.
What do I use in a query to test for an empty date?

Looking for help.

 

[SonOfEmidec1100]

This should work

WHERE EndDate IS NULL

 

[BogdanMBM]

You CAN NOT test for null values using the operator "=" because the null value is not realy a value and you can receive strange results testing null values with "=".
As mentioned above, you should use "WHERE EndDate IS NULL" instead.
Also, if you use agregate functions over a column that accepts nulls, you allways should eliminate those. Something like this:
select sum(isnull(Column_Name,0)) for an integer column.

Hope it used!
Bogdan.

 

[NeeNee]

Thanks to both of you. It worked.