SOLUTION

Forms 5.0 is capable of expanding shortened date formats (e.g. DDMMRRRR) to normal date formats (e.g. DD/MM/RRRR) correctly.

In the Oracle registry settings of Win95/98/NT (HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE) add these 2 registry settings with the following values:

• FORMS50_USER_DATE_FORMAT These are the different date formats that endusers wish to use in the form (separated by the | symbol)

   Value: DDMMRRRR|DDMMRR|DDMONRR|DDMONRRRR and so on...

• FORMS50_OUTPUT_DATE_FORMAT This is the date format Oracle expands the entered date format to (after validation).

   Value: DD/MM/RRRR

NOTE: Don't set any format masks for date fields in your forms. They get preference over these settings. They are also not necessary anymore.

George Eastlick <georgee_at_airmail.net> wrote in message news:E0D823F7C3C64763.AEE6239414E50BAB.8EA8D6D4DFB36A57_at_lp.airnews.net...
> It should be dd/mm/yyyy -- the rr is only used for two digit years.
>
> Wim Valgaeren <valgaeren_at_softhome.net> wrote in message
> news:7umv6b$qr1$1_at_naxos.belnet.be...
> > When I'm setting the format mask for a date in forms 5.0 as dd/mm/rrrr
> > and I fill in for example 01011999 then the value changes into
01/11/1999
> > instead of 01/01/1999. I think this is because of a conversion error of
> > forms.
> >
> > Can anyone confirm this and maybe have some solution, so I don't have to
> > press the / everytime I fill in a date.
> >
> > I have about 40 date items in my form, so I'll be happy if there is a
> simple
> > solution for this.
> >
> > Thanks.
> > Wim Valgaeren.
> >
> >
>
>
Received on Sat Oct 23 1999 - 05:13:43 CDT