FORMS 3.X - SYSDATE calculation problem
From: <mcgrathm_at_admin1.tcd.ie>
Date: 1997/04/22
Message-ID: <1997Apr22.120757_at_admin1.tcd.ie>#1/1
Date: 1997/04/22
Message-ID: <1997Apr22.120757_at_admin1.tcd.ie>#1/1
Hi,
[Quoted] [Quoted] I'm doing a date calculation in ver. 3.x forms that is to [Quoted] find the exact date 4 yrs ago e.g.
[Quoted] if today = 22-Apr-1997 then 4 yrs ago = 22-Apr-1993.
[Quoted] I've tried a few fixes including
[Quoted] sysdate - (4 * 365) (leap yrs )
[Quoted] to_char(sysdate,'yyyy') - 4.
[Quoted] [Quoted] I would be interested in hearing from anyone else with a solution to this puzzle.
[Quoted] TIA, Michael.Received on Tue Apr 22 1997 - 00:00:00 CEST