PDA

View Full Version : Querying dates fails



Alan Júlio
01-05-2010, 07:18 AM
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!

RolfJ
01-06-2010, 05:27 PM
This may not be of much help, but I checked the syntax and it appears fine to me. Could you post the five registers you expect to get returned by your query? Maybe there's something fishy about them.

stanl
01-09-2010, 01:54 PM
myabe >= rather than just > .02 Stan