foxpro date query help

[Timmeah]

when I do

select *
from vcsale
where saledate = {d''20070701'}

it works. But if i do

select *
from vcsale
where saledate
between {d''20070701'} and {d''20070701'}

it no work? any ideas says syntax error
but say I do just a number field and put between 1 and 100 it works fine.

Can anyone give some help here?

[Jean à Grenoble]

Can you try :

select *
from vcsale
where saledate

between {^2007-07-01} and {^2007-07-01}

the second bound must be higher or equal to the first bound.

--
Jean MAURICE
Grenoble - France - Europe
www.atoutfox.org
www.aedtf.org