Re: Forms 3.0 and dates again...

Hi Martin !

What about trying to set the input-mask on the field, so that You write mask to be dd/mm/yyyy, and then the user have to enter more than two numbers !!!!! (This is however not very user friendly...)

But anyway - You have to have a validation trigger, to validate the entered date, so if it was me, I would let the users enter 2 numbers, and do the work myself - but then remember the year 2000 .......

Good luck !

Gitte Tøgersen
Denmark

Martin Anderson skrev i meddelelsen <35780CD9.45305EAB_at_bbn.com>...
>I tried your suggestion Bruno with no success. If you set up the
INPUT_MASK to
>be dd/mm/yyyy the user can still enter a date in the format dd/mm/yy and
Forms
>accepts it with a century of 00. (i.e. 01/01/70 => 01/01/0070). I know
the
>users SHOULD enter a century but I need a mechanism that prevents them from
>entering just 2 digits for a year. Does Forms have such a mechanism? I
also
>know that I could write a trigger to check the year, etc. but I don't want
to do
>that for every form if at all possible.
>
>Thanks for the feedback.
>
>Martin
>
>Bruno Kamiche wrote:
>
>> I use forms 3.0, and just formatting the field to use dd/mm/yyyy works
fine.
>>
>> Martin Anderson wrote in message <3576DAFE.7C8548F_at_bbn.com>...
>> >How do I force a user to enter in 4-digits for a year without a
>> >trigger? I was told by Oracle that by using FMFXDD-MON-YYYY the user
>> >would be forced to enter 4 digits but when I try this NO dates are
>> >accepted (i.e. 11-OCT-1970 is rejected). Is there a way in Forms v3.0
>> >to force 4 digit years or not.
>> >
>> >Thanks In Advance, Martin
>> >
>
>
>
Received on Mon Jun 08 1998 - 14:36:54 CEST