Y2K answers and questions

[Deskin, Bob]

PowerHouse PC is a mature product and will not be officially tested or
certified for year 2000 compliance. If anyone is using PowerHouse PC, I
strongly recommend that they do their own Year 2000 testing.

1) With the SYSDATE, was the dictionary setting CENTURY INCLUDED? If it
wasn't, you won'tbe able to handle dates in more than one century.
2) The standard PHDATE range is 00-01-01 to 99-12-31. It is a century
excluded form and the dates are assumed to be within the default century.
The CENTURY INCLUDED form in PowerHouse 7.10G and 8.1x has a range from
1900-01-01 through 2027-12-31. And yes, we verified that it works.
3) Century excluded dates (6 digit dates) are assumed to be within the
default century. If you change the default century, your calculations will
be different. When we calculate DAYS on a century excluded date, we add the
default century.

For a complete explanation, check out the article at
http://www.cognos.com/suppserv/custsupp/power2000/phcentury.html

Bob Deskin              
Senior Product Advisor  bob.deskin@cognos.com
Cognos Inc.             (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA




-----Original Message-----
From: GKuetting@steinway.de [mailto:GKuetting@steinway.de]
Sent: Wednesday, February 17, 1999 3:39 AM
To: powerh-l@lists.swau.edu
Subject: Y2K answers and questions



Y2K answers and questions

PowerHouse PC

Does anyone still uses PowerHouse PC ( 5.11.G2 )?

Here are some strange observations:

1) 	Using the sysdate function with a system date of 2000-01-01 or later
in quick results in a conversion error. But there is a workaround:
removecentury(sysdate) or addcentury(removecentury(sysdate)) works fine.
Qshow also gives strange dates in the page heading ( 100-01-01 with date
format yy-mm-dd ).
2) 	The phdate format always store dates in the range of 00-01-01 to
99-01-01, regardless what you define in the dictionary. As the phdate stores
the date in two bytes ( 7 bits year, 4 bits month, 5 bits day ) it should be
possible to represent dates to the year 2027 ( I think I read this in some
manuals long years ago ).
3) 	All 6 digit date formats ( including phdate ) are giving a wrong
result in the days function with default century 20. The date 00-01-01 (
yy-mm-dd ) returns 36525 instead of 1. The 8 digit date format gives the
correct value, so you should not use mixed date formats with the days
function.
4) 	All other things ( 2000-02-29 is accepted as a valid date ) seem to
work correct.

Here is my question:

Did someone verify that the phdate date format works correct ( as mentioned
in point 2 above ) with dates until the year 2027 with PowerHouse 8.19?


> Günther J. Kütting
> Steinway & Sons
> Hamburg, Germany
> Tel +49 (40) 85 391 128
> Fax +49 (40) 85 391 205
> email GKuetting@steinway.de
> 

*
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.