[Babase] Agonism Grooming Issue Update
Karl O. Pinc
kop at meme.com
Tue Mar 27 15:39:55 EDT 2007
On 03/27/2007 02:08:38 PM, Lacey Maryott wrote:
> This will include any data which do
> not currently fall on the first being moved to the first, so that
> there should be no data existing on any day but the 1st of each month
> for all years before 1995.
The update statement for this is:
UPDATE interact ;
SET date = CTOD("1/" + MONTH(date) + "/" + YEAR(date)) ;
WHERE DAY(date) != 1 ;
AND (act = "A" OR act = "AS" OR act = "OS" OR act = "DS") ;
AND YEAR(date) < 1995
(At least I think that'd be right. My foxpro is rusty.)
Be very sure to backup the database before messing
around with this.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list