Re: Problem with date format mask , Forms 4.5.9.7

From: <frank_delisle_at_hotmail.com>
Date: Thu, 28 Jan 1999 13:52:26 GMT
Message-ID: <78pq2m$617$1_at_nnrp1.dejanews.com>


Very simple, use the mask DD-MON-RRRR instead.

  good luck!!!

In article <Pine.GSO.3.96.990127165113.8098A-100000_at_gannet.ind.tansu.com.au>,   Andrew Wallace <andrew_at_ind.tansu.com.au> wrote:
> We have an application containing many date fields all with the following
> properties :- maximum length 11
> fixed length false
> format mask DD-MON-YYYY
>
> However , if only the last 2 digits of the year are entered , the mask
> defaults the century to 00.
>
> We have been unable so far to find a suitable
> generic solution to this problem. I can`t believe I've not noticed this
> before. Potentially dates can be committed away to the database with the
> wrong century. It seems an unusual default to say the least.
>
> We dont want to have to go through every form in the application putting
> in extra code in when-validate-item triggers. Does anyone have any ideas ?
> Is this bug/quirk fixed in a later release of forms ?
>
> Any replies would be appreciated.
>
> thanks
>
> Andrew Wallace
>
>

Frank Delisle
Consultant, Eds Québec
e-mail: francois.delisle_at_prosig.qc.ca "Un problème sans solution n'est pas un problème"

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 28 1999 - 14:52:26 CET

Original text of this message