Re: SQL*Forms 3.0 displaying dates in Y2K

Hi,

Instead of making the output mask DD/MM/YY, try DD/MM/RR....

Kind regards

Gitte Tøgersen
Denmark
E-mail : gittetogersen_at_usa.net

DS skrev i meddelelsen <36C19F49.34224778_at_REMOVEMEhotmail.com>...
>Hello!
>
> Platform: SQL*Forms 3.0
> Oracle DB 7.3
>
>We have a form containing a display only (non-updatable, non-enterable)
>date field with an ouput mask of MM/DD/YY. When the form retrieves
>a record in the DB with a value of Feb. 29, 2000, it is displayed in the
>form as 29-Feb-0. Any other dates in the yr 2000 works (Jan 24, 2000
>is displayed as 01/24/00). Has anybody encountered this weird behavior?
>We have checked that the value in the DB is indeed Feb 29, 2000 and
>not Feb 29, 0000 thru SQLPLUS.
>
>Any solutions/help for this is appreciated.
>
>Thanks.
>
>PS. Remove REMOVEME from email address....
Received on Mon Feb 15 1999 - 00:00:00 CET