Kbase 16649: The Date Function uses Absolute Year - v7 and above
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
The Date Function uses Absolute Year - v7 and above
Customers may use this when they have 3 variables that they
are converting to DATE with the DATE function. When using
the DATE(month,day,year) users should bear in mind that the
year in the date function is an absolute year, and not a
year relative to the current century (as set by the -yy
startup parameter).
For example date (1,1,1) means January 1 of the year AD 1.
It cannot be displayed with a 2-digit year format. If you
say display date (1,1,1) format "99/99/9999", it works
fine. Likewise date (1,31,97) means January 31 AD 97.
Using DATE(1,31,97) will yield the following error:
** Value 01/31/097 cannot be displayed using 99/99/99. (74)
The correct way to do this is DATE(1,31,(97 + 1900)).
Progress Software Technical Support Note # 16649