Powerhouse date function bug

[Brent Gillan]

<<< Robert Edis wrote >>>
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 ran into this problem earlier, and found the following document on
Cognos web site:
http://www.cognos.com/suppserv/custsupp/power2000/phcentury.html

>From the document....
DATE returns a date based on a number of days after Dec. 31, 1899 (on
OpenVMS you can specify a base date). The returned date is century
included or excluded based on the system option. If the system option is
CENTURY EXCLUDED, the returned date must be within the DEFAULT CENTURY.
In other words, the number of days used must represent a date within the
DEFAULT CENTURY, otherwise DATE issues a data conversion error.
--------------

Brent Gillan
Aerocomp Solutions, Inc.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.