[V4RB] Query returning unmatched records ( DATE BETWEEN xxx AND yyy )

[Ivan Smahin]

Hello Stan,

Thursday, December 8, 2005, 7:34:15 PM, you wrote:

SB> Hi,

SB> Yes, this is true, I read this in SQL92 doc as well but seems it  
SB> doesn't work with Valentina.

SB> This:
SB> fldDate BETWEEN 'MM/DD/YYYY' AND 'MM/DD/YYYY'
SB> returns the right record number.

SB> This:
SB> fldDate BETWEEN DATE 'MM/DD/YYYY' AND DATE 'MM/DD/YYYY'
SB> never returns records. Never raises an exception either.

I will check it ASAP.
Could you please report it on Mantis?

-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua