[V4RB] Query returning unmatched records

[Ruslan Zasukhin]

On 11/30/05 4:39 PM, "Stan Busk" <maxprog at mac.com> wrote:

> 
> Interesting, I searched the web on how do to that, so:
> 
> WHERE ( myDate BETWEEN date'1/1/2001' AND date'1/31/2001' )
> 
> is correct? If so I will try it. myDate is a DateTime field.

You ask about syntax of BETWEEN ?

Yes it is correct.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]