Re: Q: Dates in Forms 3.0 / Oracle 7.2.2.4 / MMDDYYYY

Gary Assa wrote:
>
> Dilema:
>
> In Forms 3, we want to have a date entry assume 19YY is only a 2 digit year
> is entered. In Oracle 6.0.34, we forced input format to MM/DD/YYYY and wrote
> a little routine that did this fine. However, in 7.2.2.3, it is turning
> , for example, 06/06/95 into 06/06/0095 and 060695 into 06/06/0095.
> Is there a routine, either built in, or custom written that will take care
> of my problem?
> I have tried writing something that turns a six or eight character entry
> (assuming MMDDYY or MM/DD/YY) into this format, but MM/DD/YYY is the same
> length as MMDDYYYY, so it fails.
>
> Is there a solution???
> --
> =========================================================
> http://www.li.net/~gsa/index.html
> This is my signature file, not part of this mail message.
> I point this out since some people are just plain stupid.

It sounds like your DBA changed the default date mask in the init.ora file to something like MM/DD/RR. Or maybe it came defined that way. In either case check the date mask and change it to MM/DD/YY and it should act just like it did in your 6.0.36 environment. Keep in mind however that the year 2000 is just around the bend and that your application should be doing something to allow for it. For example is 06/12/62 = 06/12/1962 or 06/12/2062?

--
Ken Niedermeyer
Boeing Centrial Information Systems
Ken.Niedermeyer_at_boeing.com