You might try something like this:
Lcdate=date()-30
SELECT * FROM mytable WHERE thedate >?lcdate
JH
-----Original Message-----
From: profox-bounces .AT. leafe DOT com [mailto:profox-bounces@leafe.com] On Behalf
Of Jeff Johnson
Sent: Thursday, August 30, 2007 4:24 PM
To: profox .AT. leafe DOT com
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
jeff@san-dc.com
[excessive quoting removed by server]
©2007 John Harvey |
