Re: Y2K query - Forms 3.0

[Quoted] I have the same problem, but I wonder if there might be a better solution. Is there any way to get forms 3.0 to recognize 'DD-MON-RR' as the default date format? The 'RR' interprets digits 00 to 49 as 2000 to 2049 and digits 50 to 99 as 1950 to 1999. I have set NLS_DATE_FORMAT = 'DD-MON-RR' in init.ora and in sqlplus it appears to work but when you call up the same data in a form and make a change to the record, it commits it as 19nn.

Any suggestions?

Thanks,
Parker.Barrington_at_Dal.Ca

Eddie Fung wrote:
>
> We are Y2K repairing a Forms 3.0 application and have date fields
> which are using DD/MM/YY format masks. When we have date fields of
> 20nn on the database they appear as DD/MM/nn on the screen but they
> (the screen fields) seem to be containing 19nn rather than 20nn
> despite the fact that they are in the 21st rather than 20th century.
>
> It would appear that Forms 3.0 is 'defaulting' the century.
>
> Has anyone else out there come across this and if so what did they do
> (other than expanding the field to use a YYYY format) ?
>
> thanks,
>
> eddie
 

-- 
Parker Barrington
Dalhousie University
DalTech, Continuing Technical Education
http://www.cte.dal.ca/