Re: Need help with User-friendly date formats

see the registry settings

forms50_user_date_format
form50_error_date_format
forms50_output_date_format

1. forms50_user_date_format is used for entry we user MMDDRRRR for input to handle Y2K no century input
2. forms50_error_date_format is used for error trapping we make this the same as 1)
3. forms50_output_date_format we make this the standard DD-MON-YYY format as it make the most sense to read

I believe that 1) & 2) allow for multiple formats separated by a ';' in the string

add these settings to the hkey_local_machine\software\oracle as a string type.

These setting I stumbled across my looking thru the release notes acrobat file that comes with form50. It was not included in the on-line help.

I have created a .pll routine that checks these setting as the start of each form to ensure that they are set properly and if not then sets them using the d2kwutil windows API routines.

mrivera_at_calportland.com wrote in message <7lj9im$moa$1_at_nnrp1.deja.com>...
>First off, we're doing this in Forms 5.0. We're trying to find out if
>there is a way to make a date field user-friendly in the way it is
>entered. For example, a user can enter a date in any variety of
>predetermined formats, such as what is available in MS Excel, which
>would then be translated into our standard format of DD-MON-YYYY.
>
>We've been able to successfully implement this on nondatabase item
>fields. However we've run into problems getting this to work on base
>table date fields. I'm hoping for a simple solution that we could put in
>a library somewhere, but any help would be appreciated.
>
>Maynard Rivera
>Applications Analyst
>California Portland Cement Company
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Jul 04 1999 - 17:10:22 CEST