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):
returns only one register, but should be five."SELECT time, x FROM " & mTable & " WHERE time > #18/12/2009 00:00:00#"
Is the sintax correct? How can handle this database more efficiently?
Many thanks!