>When I try to reterive data using the WHERE BETWEEN too dates it doesn't work with data that is enterd
>after Y2k. My records in my solddate feild after y2k are like 01/07/00. How do I make it work?
>I'm using vfp5.0 do i need to upgrade or download a patch, Or use somthing other then between
>
>SELECT SUM(Inv.soldprice);
> FROM Inv;
> WHERE Inv.solddate BETWEEN setdate1 AND setdate2;
> into array sales
>thisform.sales.value = sales(1,1)
>
>Thanks Kelly
So what century is your date actually in? Take a look at the SET CENTURY TO and the ROLLOVER clause of that in the help. Are your "dates" even of type date, or are they character fields?