Kbase P5233: The DATE 4GL Function can only take absolute year
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 7.x
Progress 8.x
Progress 9.x
SYMPTOM(s):
** Value <value> cannot be displayed using 99/99/99. (74)
A year relative to the current century (as set by the -yy startup parameter) is being passed to the DATE 4GL Function.
CAUSE:
The DATE function only takes an absolute year. It cannot be displayed with a 2-digit year format.
FIX:
There are three options to fix this issue:
1- Pass an absolute year into the DATE Function. E.g.: DATE(1,1,2002).
2- Add 2000 to the 2-digit year before it is passed into the DATE Function. E.g.: DATE(1,31,(97 + 2000)).
3- Display the date with a 4-digit year format. E.g.: DISPLAY DATE(1,1,1) FORMAT "99/99/9999":U.