Re: Y2k Problem

1. RR is NOT working in forms 3
2. In the oracle Y2k whitepaper (available at oracle) you can find the trigger needed for data-fields in forms 3.0
3. easiest way is to make field with YYYY format mask

KKPDC_at_HOTMAIL.COM wrote:

> I am in the process of converting forms and reports for Y2K compliance. We
> are using forms 3.o and reports 1.1. The problems I face are listed below :
>
> 1. Is RR date is working inside Forms 3.?
>
> 2. For the purpose of testing, I wrote a form function y2k(wdate in date)
> ------ Starts here ---
> function y2k (fdate in date)
> return date
> is
> YY varchar2(2);
> NEW_DATE varchar2(12);
> begin
> YY := to_char(fdate,'YY');
> if to_number(YY) between 0 and 50 then
> NEW_DATE := to_char(fdate,'dd-mon-') || '20' || YY;
> return (to_date(NEW_DATE,'dd-mon-yyyy'));
> else
> return(fdate);
> end if;
> end;
> ---------Ends here --------
>
> I used this function as :adate := y2k(:adate);
> But I find the date still remain as 1900 and not as 2000.
> Could any one solve my problem please.
>
> 3. Is there any better approach ?
>
> Krishna
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon May 04 1998 - 21:33:44 CEST