Re: Forms 3.0 and dates again...

What if you set the valid range for the date field??

Martin Anderson wrote in message <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 Fri Jun 05 1998 - 23:41:05 CEST