Query Help - Case

[Bell1991]

I have the following query:

Select
Count(case(dtDate)
when null then 1
end ) dtDate ,
count(case(dtDate)
when not null then 1
end )dtDateNull
from tblName


The second case statement does not work... How can i get a count of all the dates that are null?

Thanks in advance..

-Bell

 

[Bell1991]

Got it:

Select
count(case
when dtDateis not null then 1
end )dtDateNotNull
from tblName

Thanks anyway!