You need to use nested quotes i.e. objRS.FILTER = "Date <> '' " or better
still replace them altogether with a NULL

-----Original Message-----
From: imran.saleem@b... [mailto:imran.saleem@b...]
Sent: 09 July 2002 15:13
To: ASP Databases
Subject: [asp_databases] Returning only date fields with a value


Hi,
   i am trying to return records from a recordset using a filter where the
date column in a table contains a value. Here is the code but it does not
seem to be working

objRS.FILTER = "Date <> "" "

the error i  am getting is: Provider error '80020005'
Type mismatch.

/doc/whereabs_disp.asp, line 51

The datatype of the date field in the database is of Date.

Thanks for your help.

Hi,
   i am trying to return records from a recordset using a filter where the 
date column in a table contains a value. Here is the code but it does not 
seem to be working

objRS.FILTER = "Date <> "" "

the error i  am getting is: Provider error '80020005' 
Type mismatch. 

/doc/whereabs_disp.asp, line 51 

The datatype of the date field in the database is of Date.

Thanks for your help.