Re: FORMS45 Format Mask

Yup. That's how it is. If you like, you can go back through your code and add SUBST functions to do this for you like:

TO_DATE (SUBSTR (date_to_be_validated, 1, 2) || '/' || SUBSTR (date_to_be_validated, 3, 2) || '/' || SUBSTR (date_to_be_validated, 5, 4), 'MM/DD/YYYY') I incorporated this into some code I got from Feuerstein's Oracle PL/SQL book to make a really nifty date-validation function using when-others exception handling to try to convert an inputted date from a variety of formats. Good Luck!

-Ian

Andrew M. Balshem wrote:

> We've recently converted forms from version 3.0 to 4.5 and noticed
> that the format mask (for date fields) mm"/"dd"/"yyyy no longer works
> correctly unless you completely enter all the necessary information.
> What I mean is: in version 3 we could enter the date January 1, 1997
> as 01011997 and the format mask would mask as 01/01/1997 and record in
> the database as 01-JAN-97. In version 4.5 entering the date as above
> the mask appears as 01/11/0097. Anyone else have similiar situation
> and gotten a work around other than entering the dashes (no big deal
> but a bother to our data entry personnel.)
Received on Wed Sep 17 1997 - 00:00:00 CEST