Y2K Clarification

[Deskin, Bob]

Yes that is correct. The full story is available in the article on our web
site at http://www.cognos.com/suppserv/custsupp/power2000/phcentury.html

If you have CENTURY EXCLUDED then PowerHouse "assumes" that century excluded
dates are within the DEFAULT CENTURY, so simply changing the default century
may not give you the correct data. Also, the DATE and LASTDAY functions
return century excluded dates that must be within the default century. This
isn't a problem for LASTDAY, but it means that any DATE function must deal
with a number of days since Dec 31, 1899 that falls in the default century.
This is correct behavior for PowerHouse. I believe that I posted the long
explanation a while ago. In order to deal with dates in multiple centuries,
a system should be using CENTURY INCLUDED. There are other ways to do this
through coding, but they are usually worse.

Bob Deskin              
Senior Product Advisor, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (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: Gilles Belliveau [mailto:belliveg@nbnet.nb.ca]
Sent: Friday, March 12, 1999 10:01 AM
To: PowerHouse Listserv
Subject: Y2K Clarification


Hello,

I would like it if someone could confirm something for me.

It is my understanding from what I have read on the Cognos web site that
if we have CENTURY EXCLUDED and DEFAULT CENTURY 19 in the dictionary,
then the DATE function will not be able to return a value of 2000/02/29
or any date after December 31, 1999 for that matter.

Is this correct or is there a way the DATE function can still give us
February 29, 2000 without causing a data conversion error? 
(I was not the one who did the Y2K conversion, but I am now the one who
is testing and debuging it because the person who did the conversion is
currently on maternity leave, so my knowledge of Y2K issues is limited)

Thanks,
Gilles Belliveau
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.