Kbase P25092: Is it possible to make a date format like YY/MM/DD with CorVu?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/3/2004 |
|
Status: Unverified
GOAL:
Is it possible to make a date format like YY/MM/DD with CorVu?
GOAL:
CorVu and dates
FACT(s) (Environment):
CorVu 4.20
FIX:
CorVu stores database specific date information in a configuration file called, "dbms.kif". The stored format for a Progress database is MM/DD/YYYY. For date fields that do not conform to the database defaults, CorVu's Knowledge Library module can be used to set a "Data Type Override". This feature can be used to set a translation between prompted input and information in the database.
It is, however, not possible to create a format like YY/MM/DD for the data override format.
The reason why YY/MM/DD isn't possible is because potentially you could get leading zeros appearing in the YY entry. The engine would interpret these as a DD or MM entry, and the entries would be inverted.
The engine generally works in the following way with dates:
CorVu checks the entered date against the Windows Regional settings. If the entered date can match the regional format, CorVu will use this format. If the regional setting cannot be used, CorVu attempts to interpret in the following manner. First, it scans the input for a three or more letter month. Then, starting at the beginning of the string, CorVu interprets the first number under 32 as a day. If the month was not already determined, the next number found under 12 is used for the month. Whatever number is left over will automatically be calculated as a year. This can cause a date entered as 1/3/01 to be interpreted as March 1.
Furthermore, CorVu discourages the use of two-digit years, but when one is entered, it is interpreted as follows. A number (XX) under 50 is interpreted as 20XX, while XX is above 50 it will be interpreted as 19XX.