Re: forms 3.0/difference bet dates

mcgrathm_at_admin1.tcd.ie wrote:
>
> Hi ,
>
> I wonder can I share a development problem I've run into with forms 3.x.
>
> A form has to automatically calculate the number of years and months
> between two dates e.g. between 13-MAR-1997 AND 13-MAR-1998 would
> be represnted as 01.00 (YY.MM). The difference between 13-mar-97
> and 13-apr-1997 would be 00.01.
>
> I've been unable to develop a script/procedure to solve this
> problem and wonder has anyone else encountered a simliar problem
> ?
>
> TIA,
>
> Michael.

Hi,

   Use the function months_between() to get the months between the two dates and if it is > 12 the calculate the years and months.

Thanks & Regards

K.Rajesh
Oracle DBA Received on Fri Mar 14 1997 - 00:00:00 CET