Re: SQL*Forms 3.0 displaying dates in Y2K

In article <36C19F49.34224778_at_removemehotmail.com>,

        DS <danny118_at_REMOVEMEhotmail.com> writes:
> 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....

Is the field in question a DATE field? If so, specify the right format mask and adjust the field length. In all our forms, all DATE fields have format mask DD-MM-YYYY.

Remco

-- 
rd31-144:  2:05am  up 5 days, 22 min,  7 users,  load average: 1.45, 1.34, 1.18