Hi folks,

I have an access database where there is a field with date format dd/mm/yyyy hh:mm:ss

So, when I try to get data using sql comparasion statements the data comes incomplete. For example (x and time are two of the fields of mTable): 

"SELECT time, x FROM " & mTable & " WHERE time > #18/12/2009 00:00:00#"
returns only one register, but should be five.

Is the sintax correct? How can handle this database more efficiently?

Many thanks!