Re: FORMS 3.X - SYSDATE calculation problem
From: Michael Nolan <nolan_at_inetnebr.com>
Date: 1997/04/22
Message-ID: <5jj6md$66s$1_at_falcon.inetnebr.com>#1/1
Date: 1997/04/22
Message-ID: <5jj6md$66s$1_at_falcon.inetnebr.com>#1/1
mcgrathm_at_admin1.tcd.ie writes:
> I'm doing a date calculation in ver. 3.x forms that is to
> find the exact date 4 yrs ago e.g.
>
> if today = 22-Apr-1997 then
> 4 yrs ago = 22-Apr-1993.
How about using add_months? add_months(sysdate,-48) will give you 4 years ago's date, then if you need a 4 digit year you can manipulate it with to_char. This works in Forms 3.0, I just tried it.
-- Mike NolanReceived on Tue Apr 22 1997 - 00:00:00 CEST