Re: Forms 3.0 and dates again...

Simply put your format mask infront of the year as in "DD-MON-FXYYYY". "DD-MON-YYYY" format will let you enter a two digit year and prefix it with two zeros.
Good luck.

Iain Airlie wrote in message <01bd952e$2d9cb1c0$8109c18f_at_ukd05402>...
>We have just set the format mask to DD-MON-YYYY on all date fields. works
>perfectly every time: users have to enter 4-digit years, and 29-Feb-2000 is
>accepted quite happily. And that is on a 7.1.5.2 database.
>
>Robert Fernandes <rfernand_at_llnl.gov> wrote in article
><357C193B.10EA143A_at_llnl.gov>...
>> Martin Anderson wrote:
>> >
>> > 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
>[snip]
Received on Sat Jun 13 1998 - 00:00:00 CEST