Re: Problem with Date Format Mask

From: Manuel Jerez <mjerez_at_most.satlink.net>
Date: Tue, 11 Aug 1998 16:12:32 -0300
Message-ID: <35D0979F.B00253A0_at_most.satlink.net>


May be you can try this one:

 DD/MM/RRRR I'm using Developer 2000 1.51 for Windows NT and works fine...

Regards...

                                Manuel Jerez.


Todd Owers wrote:

> Don,
>
> To be able to enter dates without delimiters and have the form automatically
> put them in, you will have to write code to do it. It's not a simple, easy
> thing to do.
>
> The treatment of dates without delimiters is different in Forms 4.X than it
> was in SQL*Forms 3.0. The "Forms 4.5 Common Questions and Answers" document
> (found under Programs -> Developer 2000 for Win95-> Forms Q&A) explains the
> reason for this under section 14, "Upgrading From Previous Releases."
>
> If you have access to the Oracle MetaLink web site, the following documents
> provide more detailed information, including code examples of a workaround:
>
> Bulletin 11378961.61, "How to Manipulate a Date Without Delimiters in Forms
> 4"
> Prob# 1010769.6, "(V4.X) Inputting Dates Without Delimiters Using Oracle
> Forms"
> Prob# 1004682.6, "Date Incorrect if Entered Without Delimiters Into Format
> Mask in Forms 4.X"
>
> Good luck,
> Todd Owers
>
> Don Haney wrote in message <35CF3696.AE59EA19_at_ornl.gov>...
> >Greetings,
> >
> >I am having trouble with a format mask on a date field. I'm using
> >version 4.5 of Forms with the Developer 2000 interface. What I want is
> >the user to enter a numerical date, such as '05121998', with the obvious
> >format of MM/DD/YYYY and have the slashes supplied by the form. My
> >current format mask is FMMM"/"DD"/"YYYY and I have tried many variations
> >of this. When values are entered into the field and the user navigates
> >out, the value becomes '05/21/0098'. If I tried a string of '07201998',
> >I get a message that the date must be in the format of FMMM"/"DD"/"YYYY.
> >
> >I have done this in Oracle before and know that it is possible. I had
> >someone on another Oracle application try the format mask and it works
> >as expected. Does anyone have any suggestions? Please reply by E-mail
> >or post it here.
> >
> >Thanks for your suggestions,
> >
> >Don Haney
> >
> >
Received on Tue Aug 11 1998 - 21:12:32 CEST

Original text of this message