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