Re: Date Format Masks

[Quoted] David Fenton <dfenton_at_geopower.com> wrote:

>Am I losing my memory or was it once possible to use a format mask like
>MM"-"DD"-"YYYY to allow users
>to enter the date as 11121998 and it would be displayed as 11-12-1998.
>I've been trying it with Forms 5 and it recognizes the 3 and 6 numbers
>as delimiters.
>
>If someone could let me know if this was ever possible or if I am not
>using the format mask properly.
>
>Thanks in advance.
>
>David
>
>
>
The mask can be for output ( to_char(date,'MM-DD-YYYY') or for input ( set the forms field format to MM-DD-YYYY) ; this will expect the dashes as part of the input ) but if you want to ensure Y2K compliance you should use an input mask and force 4 digit year entry by using FXMM-DD-YYYY - this will REQUIRE that the user input exactly something like 12-21-1998 ( including the dashes ) or use FXMMDDYYYY as the input mask and use the output format to add the dashes.

Hope it helps,
John Greco
Oracle DBA
EMail to john.greco_at_dot.state.mn.us
.. Received on Tue Jul 14 1998 - 17:11:50 CEST