[HP3000-L] QUIZ/QTP Differences?

Chris Sharman chris.sharman@ccagroup.co.uk
Mon, 15 Apr 2002 09:18:20 +0100


It looks to me very like the 2nd (QTP) run is assuming year 1904, not 2004.
Check out the default century etc in the default dictionary.

Chris Sharman

> -----Original Message-----
> From: Harrington, Don [mailto:don.harrington@boeing.com]
> Sent: 12 April 2002 22:25
> To: mx% joan_entwistle@tufts-health.com
> Cc: mx% hp3000-l@raven.utc.edu; mx% powerh-l@lists.swau.edu
> Subject: RE: [HP3000-L] QUIZ/QTP Differences?
> 
> 
> 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: Joan_Entwistle@tufts-health.com
> [mailto:Joan_Entwistle@tufts-health.com]
> Sent: Friday, April 12, 2002 1:25 PM
> To: Harrington, Don
> Cc: HP3000-L@RAVEN.UTC.EDU
> 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
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to 
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> ------------------------------------------------------------------
> --------------
> Date: Fri, 12 Apr 2002 14:25:04 -0700
> 


-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.