You might try something like this: Lcdate=date()-30
SELECT * FROM mytable WHERE thedate >?lcdate JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Johnson Sent: Thursday, August 30, 2007 4:24 PM To: [email protected] Subject: Date Problems I am using VFP9 and I do a SELECT * FROM mytable WHERE thedate > DATE(2007, 5, 1) and it selects the correct records, but changes the dates in the result cursor to garbage. I have been doing quite a bit with dates on this project and any time I use a WHERE clause or SET FILTER TO or IF thedate < ldsomedate, the dates get garbled. When I remove the filter or selection it gives me the same result set, but the dates in the result are correct. This is very puzzling to me. Jeff Jeff Johnson [EMAIL PROTECTED] [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
