Re: (Q) Subtract 6 months from a date: result=error -1267!!!
In article <2ofj0n$848@emory.mathcs.emory.edu>,
Robert Minter <rob@dssmktg.com> wrote:
>>> From Joey Duhon:
>>> [4gl code deleted]
>>> Now try it in ISQL. (-:
-- for test purposes
create temp table orig
(
orig datetime year to day
);
create temp table delta
(
delta smallint
);
insert into orig values (today);
insert into orig values ("94-03-31");
insert into orig values ("92-02-29");
insert into delta values (6);
insert into delta values (2);
select orig, day(orig) - 1 dayx, extend(orig, year to month) monthx
from orig
into temp t1;
select orig, delta back,
extend(monthx - (delta - 1) units month, year to day) nextx,
extend(monthx - delta units month, year to day) + dayx units day plusx
from t1, delta
into temp t2;
select orig, back, extend(nextx, year to day) - 1 units day old
from t2
where plusx >= nextx
union select orig, back, plusx old
from t2
where plusx < nextx;
joey