Re: 4 digit year problem

There is a program unit called FIX_DATE. This is available in Oracle Technical bulletins. It concatenates the appropriate year masks when the user inputs two digits. We use fix_Date on when-validate-item trigger on each date item and it works great.

If you can't find it let me know. I modified the code for our application, but still may be useful for you.

HTH Prasad Chavali

Savithri Devaraj <sdevaraj_at_csc.com> wrote in article <352CE8CA.16377CDD_at_csc.com>...
> We use Developer 2000 forms 4.5 on our project here. Many of our forms
> have a date input in them. We have defined the format for the date as
> MM/DD/YYYY. Inspite of this, the user is allowed to input a 2 digit
> year. Does anyone know how i can force the user to enter a 4 digit year
> always?
> For eg, if the user inputs 98, it is interpretted as 0098.
> Any clues, how i can enforce the user to enter 0098 or 1998?
>
> Thanks a lot for any suggestion
> Savithri
>
>
  Received on Thu Apr 09 1998 - 00:00:00 CEST