Retrieving data from a database using SQL statements

I have got the following SQL statement which will retrieve all the records where date is > 1/1/1998

Select * from R_List where Date > '6/2/1999 23:59:59'

This works fine when the database is Oracle but when the database is anything else ie Access then I get an error message.

What is the correct SQL for filtering on date fields which would work on all database types?

Thanks in advance for the help Received on Wed Jun 02 1999 - 09:47:49 CDT