openquery function in sql

[JeremyF]

Why does this:

SELECT * FROM openquery(linkedservername, 'select * from table where date = ''3/19/01''')

...not work?! It gives me an error like:

Incompatible data types in expression or assignment.

How do I filter on the date in an openquery statment?

:smurf: