y2k revisited?
Deskin, Bob
Bob.Deskin@Cognos.COM
Thu, 26 Feb 2004 15:25:19 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3FCA5.F5EB3D06
Content-Type: text/plain
The issue here is that the date is declared as CENTURY EXCLUDED. Any century
excluded date is assumed to be in the default century. The option is named
"INPUT CENTRUY" and applies to input only. It does not apply to existing
data not does it apply to century excluded dates. It was designed so that
pre-existing (pre-Y2K) screens did not have to be modified where they
allowed a year entry without the century into a century included date.
Century excluded dates still had to be converted.
So the defined item gives you 19000229 which is an invalid date because
there was no Feb 29, 1900 based on the rule of 400.
Bob Deskin
Senior Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com]
Sent: February 26, 2004 3:19 PM
To: Powerhouse List (E-mail)
Cc: Deskin Bob (E-mail)
Subject: y2k revisited?
Anybody got any ideas about this one?
I've logged a "case" with Cognos but I thought somebody out there might have
found and fixed this one already. We're moving to a new machine and a new
version of MPE and are taking the opportunity to upgrade PowerHouse versions
at the same time. So what's with the error below in 8.49.C?
The dictionary options include:
Century INCLUDED &
Input Century 19 From Year 50 &
Any help appreciated.
Regards,
JWP
Q U I Z (PowerHouse 8.19.C4)
Copyright 1999 COGNOS INCORPORATED
Norbord Industries Inc.
> def d-date-ce date century excluded = 000229
> rep all
> go
04/02/26 Norbord Industries Inc. PAGE
1
D-DATE-CE
00/02/29
Q U I Z (PowerHouse 8.49.C)
Copyright 2003 COGNOS INCORPORATED
Norbord Ind.
> def d-date-ce date century excluded = 000229
> rep all
> go
04/02/26 Norbord Industries Inc. PAGE
1
D-DATE-CE
########
?
Records selected: 0
Lines printed: 3
Pages printed: 1
** Data conversion errors: 1
>
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C3FCA5.F5EB3D06
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2657.73">
<TITLE>RE: y2k revisited?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>The issue here is that the date is declared as =
CENTURY EXCLUDED. Any century excluded date is assumed to be in the =
default century. The option is named "INPUT CENTRUY" and =
applies to input only. It does not apply to existing data not does it =
apply to century excluded dates. It was designed so that pre-existing =
(pre-Y2K) screens did not have to be modified where they allowed a year =
entry without the century into a century included date. Century =
excluded dates still had to be converted.</FONT></P>
<P><FONT SIZE=3D2>So the defined item gives you 19000229 which is an =
invalid date because there was no Feb 29, 1900 based on the rule of =
400.</FONT></P>
<P><FONT SIZE=3D2>Bob =
Deskin =
</FONT>
<BR><FONT SIZE=3D2>Senior Product Manager, Application Development =
Tools, Cognos Inc.</FONT>
<BR><FONT SIZE=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: =
(613) 727-1178</FONT>
<BR><FONT SIZE=3D2>3755 Riverside Drive, Ottawa ON K1G 4K9 =
CANADA</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Pickering, John (NORBORD) [<A =
HREF=3D"mailto:PICKERIJ@norbord.com">mailto:PICKERIJ@norbord.com</A>] =
</FONT>
<BR><FONT SIZE=3D2>Sent: February 26, 2004 3:19 PM</FONT>
<BR><FONT SIZE=3D2>To: Powerhouse List (E-mail)</FONT>
<BR><FONT SIZE=3D2>Cc: Deskin Bob (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: y2k revisited?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Anybody got any ideas about this one?</FONT>
</P>
<P><FONT SIZE=3D2>I've logged a "case" with Cognos but I =
thought somebody out there might have found and fixed this one already. =
We're moving to a new machine and a new version of MPE and are taking =
the opportunity to upgrade PowerHouse versions at the same time. So =
what's with the error below in 8.49.C?</FONT></P>
<P><FONT SIZE=3D2>The dictionary options include:</FONT>
</P>
<P><FONT SIZE=3D2> Century INCLUDED &</FONT>
<BR><FONT SIZE=3D2> Input Century 19 From Year 50 &</FONT>
</P>
<P><FONT SIZE=3D2>Any help appreciated.</FONT>
</P>
<P><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>JWP</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Q U I Z (PowerHouse 8.19.C4)</FONT>
<BR><FONT SIZE=3D2>Copyright 1999 COGNOS INCORPORATED</FONT>
<BR><FONT SIZE=3D2>Norbord Industries Inc.</FONT>
</P>
<P><FONT SIZE=3D2>> def d-date-ce date century excluded =3D =
000229</FONT>
<BR><FONT SIZE=3D2>> rep all</FONT>
<BR><FONT SIZE=3D2>> go</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>04/02/26 &=
nbsp; Norbord =
Industries =
Inc. &n=
bsp; PAGE</FONT>
<BR><FONT SIZE=3D2>1</FONT>
</P>
<P><FONT SIZE=3D2> D-DATE-CE</FONT>
</P>
<P><FONT SIZE=3D2> 00/02/29</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2>Q U I Z (PowerHouse 8.49.C)</FONT>
<BR><FONT SIZE=3D2>Copyright 2003 COGNOS INCORPORATED</FONT>
<BR><FONT SIZE=3D2>Norbord Ind.</FONT>
</P>
<P><FONT SIZE=3D2>> def d-date-ce date century excluded =3D =
000229</FONT>
<BR><FONT SIZE=3D2>> rep all</FONT>
<BR><FONT SIZE=3D2>> go</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>04/02/26 &=
nbsp; Norbord =
Industries =
Inc. &n=
bsp; PAGE</FONT>
<BR><FONT SIZE=3D2>1</FONT>
</P>
<P><FONT SIZE=3D2> D-DATE-CE</FONT>
</P>
<P><FONT SIZE=3D2> ########</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>?</FONT>
</P>
<P><FONT SIZE=3D2>Records selected: 0</FONT>
<BR><FONT SIZE=3D2>Lines printed: 3</FONT>
<BR><FONT SIZE=3D2>Pages printed: 1</FONT>
</P>
<P><FONT SIZE=3D2>** Data conversion errors: 1</FONT>
</P>
<P><FONT SIZE=3D2>> </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>This message may contain privileged and/or =
confidential information. If you have received this e-mail in =
error or are not the intended recipient, you may not use, copy, =
disseminate or distribute it; do not open any attachments, delete it =
immediately from your system and notify the sender promptly by e-mail =
that you have done so. Thank you.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C3FCA5.F5EB3D06--