powerHouse date function bug

Cousins, Michael Michael.Cousins@Cognos.COM
Wed, 14 Oct 1998 17:16:04 -0400


The problem date in your example should return (mm/dd/yyyy) 01/06/2000 - 5
days = 01012000, which is a data exception error within the circumstances of
your code.

> ----------
> From: 	Robert J.M. Edis[SMTP:Robert.Edis@creatcomp.com]
> Sent: 	Wednesday, October 14, 1998 4:31 PM
> To: 	'powerh-l@lists.swau.edu'
> Subject: 	re: powerHouse date function bug
> 
> Brent Gillan wrote:
> 
> "In other words, the number of days used must represent a date within
> the
> DEFAULT CENTURY, otherwise DATE issues a data conversion error."
> Excerpted from the Cognos page phcentury.html.
> 
> But the date in my example should return 19000101 which IS a valid date
> in the default century (19)!
> 
> Blue
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 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.