Re: Forms 3.0 and dates again...
From: Iain Airlie <ima84531_at_GlaxoWellcome.co.uk>
Date: 11 Jun 1998 11:41:51 GMT
Message-ID: <01bd952e$2d9cb1c0$8109c18f_at_ukd05402>
> >
> > 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 Thu Jun 11 1998 - 13:41:51 CEST
Date: 11 Jun 1998 11:41:51 GMT
Message-ID: <01bd952e$2d9cb1c0$8109c18f_at_ukd05402>
[Quoted] 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 Thu Jun 11 1998 - 13:41:51 CEST