Re: Problem with date format mask , Forms 4.5.9.7

Another option is to use the "FX" toggle to enforce the data entered matches exactly the format mask, Eg.

DD-MON-fxYYYY

Will enforce the entry of all four digits, whilst

fxDD-MON-YYYY

Will ensure that the entire date matches this mask, including leading zeroes in the day number field.

Regards,
Ian Holmes
BHP Information Technology

Andrew Wallace <andrew_at_ind.tansu.com.au> wrote in article <Pine.GSO.3.96.990127165113.8098A-100000_at_gannet.ind.tansu.com.au>...
> We have an application containing many date fields all with the following
> properties :- maximum length 11
> fixed length false
> format mask DD-MON-YYYY
>
> However , if only the last 2 digits of the year are entered , the mask
> defaults the century to 00.
>
> We have been unable so far to find a suitable
> generic solution to this problem. I can`t believe I've not noticed this
> before. Potentially dates can be committed away to the database with the
> wrong century. It seems an unusual default to say the least.
>
> We dont want to have to go through every form in the application putting
> in extra code in when-validate-item triggers. Does anyone have any ideas
?
> Is this bug/quirk fixed in a later release of forms ?
>
> Any replies would be appreciated.
>
> thanks
>
> Andrew Wallace
>
>
>
>
Received on Mon Feb 01 1999 - 22:57:25 CET