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

[Stan Busk]

Hi,

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

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

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

Stan

> Hello Stan,
>
> Wednesday, November 30, 2005, 4:39:33 PM, you wrote:
>
> SB> Interesting, I searched the web on how do to that, so:
>
> SB> WHERE ( myDate BETWEEN date'1/1/2001' AND date'1/31/2001' )
>
> SB> is correct? If so I will try it. myDate is a DateTime field.
>
> SB> Stan
>
> You still should use the dates as defined by current dateFormat.
> Date/DateTime/Time  literals  just gives  a  way  to  remove  some
> internal ambiguities.
>
> BTW. Using such literals is required by SQL-92.
>
>
> -- 
> Best regards,
>  Ivan                            mailto:IvanSmahin at public.kherson.ua
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina