where date is greater than

[lpasotti]

I have linked into out financial database which is a progress database. All has been working fine except for working with dates.
I quite simply want to select all the rows where the date is greater than a specified date.
I have tried the following and none work

SELECT * FROM chart
WHERE DateUpd > "08/10/2002"

SELECT * FROM chart
WHERE DateUpd > '08/10/2002'

SELECT * FROM chart
WHERE DateUpd > "08/10/02"

SELECT * FROM chart
WHERE DateUpd > '08/10/02'

I am linking to the database from SQL server using the Merant Progress Dirver. I get the folowing error each time I try to run the query.

Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.

To execute the SQL I am using the OPENQUERY method
i.e.
SELECT * FROM OPENQUERY(DATABASE1,'SELECT * FROM table1
WHERE DateUpd > "08/10/2002"')

Any help here would be greatly appriciated
Thanks,
Luke

 

[lpasotti]

Worked it out.
Just needed to take away the quotes
I now have

SELECT * FROM OPENQUERY(DATABASE1,'SELECT * FROM table1
WHERE DateUpd = 05/12/2002')

Luke