Recent content by 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

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...