Re: Date Format Masks

If you use the format mast "mm/dd/rrrr" you can enter the date as 1.2.98 and it will reformat the screen as 01/02/1998. Also if you enter "2.13.5" it would display it as "02/13/2005". You can also enter the full century to get any century you like.

Brian

TurkBear wrote in message <35ab73c3.4934285_at_news2.mm.com>...
>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 Wed Jul 15 1998 - 07:25:02 CEST