Re: Problem with Date Format Mask

Don,

[Quoted] 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 - 19:58:31 CEST