Y2K answers and questions

[Bert de Nooij]

Gunther,

Have look at the Cognos Supported Area http://www.cognos.com/htsup/suppinfo.ht/search_kb.html
and search for wedge and IX, there you'll find more info about  phdates on IX.

About PH PC, it's a mature product, and Cognos will not test it  for Year 2000 compliancy. Do I need to say more.

Bert de Nooij
Arma B.V. 



-----Oorspronkelijk bericht-----
Van:	GKuetting@steinway.de [SMTP:GKuetting@steinway.de]
Verzonden:	woensdag 17 februari 1999 9:39
Aan:	powerh-l@lists.swau.edu
Onderwerp:	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?


> Gunther J. Kutting
> 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.