[V4RB] Query returning unmatched records

[Stan Busk]

Hi,

I have the following query:

SELECT SUM(myField)
FROM myTable
WHERE ( myDate BETWEEN '1/1/2001' AND '1/31/2001' )
AND aMisc1 = false
AND aMisc2 = false

It returns records however they are not matching the query, actually  
it never returns what it should.
Is there anything I should know? I can't see why that query doesn't  
work right now.

TIA,
~/Stan