HP3000-L Archives

April 2002, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Joan Entwistle <[log in to unmask]>
Reply To:
Date:
Fri, 12 Apr 2002 16:24:54 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (30 lines)
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 *

ATOM RSS1 RSS2