Problem with date format mask , Forms 4.5.9.7
From: Andrew Wallace <andrew_at_ind.tansu.com.au>
Date: Wed, 27 Jan 1999 17:04:39 +1100
Message-ID: <Pine.GSO.3.96.990127165113.8098A-100000_at_gannet.ind.tansu.com.au>
[Quoted] [Quoted] We have an application containing many date fields all with the following properties :- maximum length 11
Date: Wed, 27 Jan 1999 17:04:39 +1100
Message-ID: <Pine.GSO.3.96.990127165113.8098A-100000_at_gannet.ind.tansu.com.au>
[Quoted] [Quoted] 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 Received on Wed Jan 27 1999 - 07:04:39 CET
