Issue with null field in select statment where clause

[#1]

I am having an issue with a where clause. I am trying to filter job selection based on the closed date. If the job is open, then this field is blank. I want jobs that have been closed >= to this year, or open jobs that have not been closed.

The following is not working.

FROM ... where year(closeddate)>=2012 or Isnull(closeddate) ;

I have also tried:

FROM ... where year(closeddate)>=2012 or Isnull(closeddate)=-1 ;

FROM ... where year(closeddate)>=2012 or len(closeddate)=0 ;

Any one have any ideas?

[#2]

Hi!

Can u upload ur App. ?

[#3]

I am not able to upload the app.

This is the error I get when I try and use FROM ... where year(closeddate)>=2012 or Isnull(closeddate) ;

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: The isnull function requires 2 argument(s).

[#4 · Accepted solution]

I found the solution:

FROM ... where year(closeddate)>=2012 or closeddate IS NULL;