Powerhouse date function bug

[Robert J.M. Edis]

G'day good people

There is a bug in PowerHouse that's causes a DCE when using the DATE()
function and the PHD is CENTURY EXCLUDED.  If the function will result
in a date after 12/31/1999 the Data Conversion Error occurs.

I had a look at Cognos's web site knowledge base but the closest
reference I could find says this occurs only with the date 02/29/2000.
We have tested this issue with 7.29C8, 7.09 and 6.20E with the same
result in each case.  Here is an example of code:

DEFINE date1 DATE [CENTURY INCLUDED] = PARM [FORMAT MMDDYYYY]
DEFINE days1 = DAYS(date1) - 5
DEFINE date2 DATE [CENTURY INCLUDED] = DATE(days1)
REPORT date1 FORMAT MMDDYYYY date2 FORMAT MMDDYYYY

Note: syntax in [ ] is optional and makes no difference to outcome.

Input values:  10141998, 12311999, 01012000, 01052000, 01062000

Results:
Date1           Date2
10/14/1998  10/09/1998
12/31/1999  12/26/1999
01/01/2000  12/27/1999
01/05/2000  12/31/1999
01/06/2000  DCE

Has anyone out there found a work around to this problem other than
changing the PHD to CENTURY INCLUDED? 

Robert "Blue" Edis
Creative Computing Inc.
Rhode Island, 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.