Hmm.  Well, the definitions for the START-DATE, NEW-DATE and (MY-)CHRON-SEQ
are the same in both the QUIZ report and the QTP process.

Don Harrington
Sr. Systems Analyst
Facilities Applications Support
Shared Services Group
The Boeing Company
P.O. Box 3707 M/C 2R-32  NEW!
Seattle, WA  98124-2207
(v) 206-544-5679  NEW!  (f) 206-544-5788  NEW! (p) 206-797-6360

The opinions expressed in this e-mail reflect those of the sender.  They do
not necessarily reflect the opinions of The Boeing Company unless
specifically stated otherwise.



-----Original Message-----
From: [log in to unmask]
[mailto:[log in to unmask]]
Sent: Friday, April 12, 2002 1:25 PM
To: Harrington, Don
Cc: [log in to unmask]
Subject: Re: [HP3000-L] QUIZ/QTP Differences?



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 *