Re: Forms 3.0 and dates again...

[Quoted] [Quoted] I tried your suggestion Bruno with no success. If you set up the INPUT_MASK to [Quoted] [Quoted] be dd/mm/yyyy the user can still enter a date in the format dd/mm/yy and Forms [Quoted] [Quoted] accepts it with a century of 00. (i.e. 01/01/70 => 01/01/0070). I know the [Quoted] users SHOULD enter a century but I need a mechanism that prevents them from [Quoted] entering just 2 digits for a year. Does Forms have such a mechanism? I also [Quoted] [Quoted] know that I could write a trigger to check the year, etc. but I don't want to do [Quoted] that for every form if at all possible.

[Quoted] 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 - 17:22:58 CEST