[V4RB] Query returning unmatched records // fixed.

[Stan Busk]

I have found the solution, use of kMDY as the dateformat.

~/Stan

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina