Kbase 15526: Error 74 When Displaying Dates with -yy Option.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
SYMPTOM(s):
** Value <value> cannot be displayed using <format>. (74)
Error 74 can occur when the -yy option is either changed to a different value or dropped altogether (which constitutes a change).
Example:
Value "03/30/2000" cannot be displayed using "99/99/99". (74)
CAUSE:
When you change the -yy option, PROGRESS tries to display the previously stored dates from the database with the full century format. Example: 1925, 2000. The new dates entered with changed -yy option can be displayed with '99/99/99'.
FIX:
1) Ideally, the database field should be modified to the format,
"99/99/9999".
2) If that is not possible then the display can be modified as:
DISPLAY date-field FORMAT "99/99/9999".