Y2K testing

[Shawn Gordon]

The virtual date/time products are invaluable to really times, I use
TimeWarp.  I ran across a rather bizarre set of code that was meant to
create a date that was the first day of the current month, and the last day
of the prior month.  Consider the following code;

DEF A CHAR*6 = ASCII(SYSDATE)
DEF B CHAR*6 = A[1:4]+"01"
DEF C DATE = NCON(B)
DEF D DATE = DATE(DAYS(C)-1)
DEF E CHAR*6 = ASCII(D)
DEF F CHAR*4 = E[1:4]
REPORT A B C D E F

If the current date were 10/29/98 you would get the following
A = 981029
B = 981001
C = 10/01/98
D = 09/30/98
E = 980930
F = 9809

Now if the date is 10/29/01 you get the following
A = 11029
B = 110201
C = 02/01/11
D = 01/31/11
E = 110131
F = 1101

Because of the NCON function stripping leading zeroes and casting back into
a date, you get all sorts of bizarre results that you won't catch unless
you are using a future date.  In this example you probably could have just
hard wired the future date, but it illustrates the point.

shawn






John Pearce <jpearce@rmi.net> on 12/21/98 07:54:05 PM

To:   powerh-l@lists.swau.edu
cc:    (bcc: Shawn Gordon/IS/FHM/FHS)
Subject:  Y2K testing




Seasons Greetings!

The PH apps at this site have used four digit years since 1990 (no, it
wasn't great planning).  We will finish converting to PH8.19C in late
January.  We've checked the PH code using the top ten problem areas listed
in a recent support newsletter and didn't find anything.  We've also
checked the JCL for conditional execution of QTP & Quiz and found that it's
simply a case of a file existing or not existing, i.e., not date related.

What's the feeling on this list about setting the system clock ahead (or
using a date intercept program) and testing?  Is it A) mandatory, B) nice
to do, or C) not necessary?
I'd really like to get input from the Cognos people even if it's just their
own personal opinion and/or via private e-mail.

I made a decision a month ago and now I'm rethinking it so I'd like some
input from the list members.

Thanks.


------------------------------------------------------------------
John Pearce  <jpearce@rmi.net>       | Bethesda Management Company
Speaking for only myself             | Colorado Springs, CO  USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.