Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date conversion error in forms 5.0

Re: Date conversion error in forms 5.0

From: RAVICHANDRAN <ravis_at_gto.net.om>
Date: Thu, 21 Oct 1999 20:12:49 +0400
Message-ID: <7uob0m$h7r3@OM9.omantel.net.om>


It is true that I too get the same error. This is because you have the format mask as dd/mm/rrrr and type only the numbers and not the '/' OR ANY PERIODS You may try the following.
Set the property of the date field as follows.

max length             8
fixed length           yes
format mask         DDMMRRRR ( without ' / ' )
Then it works fine without any error
Ravichandran Received on Thu Oct 21 1999 - 11:12:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US