Well, I finally located our powerhouse documentation, and here is the
definition of the days function:
If the century prefix is 19 or greater, DAYS converts the number of
days since and including Monday, January 1, 1900. If the century
prefix is less than 19, the date is converted to a negative number that
represents the days prior to Sunday, December 31, 1899.
So, I'm guessing that in the Quiz report there is no century, and it
assumes 19 for century (like in pre-y2k), but in the qtp, the date does
contain the century, or that QTP has been told to assume 20 for century.
Here is what Quiz does on our system:
> def days1 num = days(040101)
> def days2 num = days(20040101)
> rep days1 days2
DAYS1 DAYS2
1461 37986
Hope this helps.
Joan
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|