Re: Date conversion error in forms 5.0

((Newsgroups trimmed to cdo.tools. Forms questions belong ONLY in the tools newsgroup))

In article <7umv6b$qr1$1_at_naxos.belnet.be>, Wim Valgaeren <valgaeren_at_softhome.net> wrote:
>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.

With your format mask of dd/mm/rrrr, Forms is taking the input and ignoring the third and sixth characters (where the / characters are in the format mask). So it is finding 01x11x99, then applies the RR translation and comes back with 1999 for the century.

There may be a way to set input date format differently to the display format in Forms 5 or 6, but certainly not in 4.5 which is what I still use.

We just tell our users to use DDMMYY for every date, and they get used to viewing dates that way. For display-only dates, we include the / characters. We use our own function to set the century correctly.

Steve Cosner Received on Thu Oct 21 1999 - 19:05:32 CEST