Problem with Date(days()) functions

[Karl Pohl]

Hi
something must be wrong on your setup -- I have the same version and it works
fine
here is an example:

Q U I Z   (PowerHouse  8.19.C3)
Copyright 1998 COGNOS INCORPORATED

  DEF DT DATE CENTURY INCLUDED = 20000201
  DEF ND DATE CENTURY INCLUDED = DATE(DAYS(DT) - 4)
> REP DT ND
> GO

      DT          ND

  2000/02/01  2000/01/28

  DEF DT DATE CENTURY INCLUDED = 20000101
  DEF ND DATE CENTURY INCLUDED = DATE(DAYS(DT) - 4)
> REP DT ND
> GO


      DT          ND

  2000/01/01  1999/12/28

Joseph Northrop wrote:

> We are having a problem with the DATE(DAYS())
> function that we normally use to add a certain #
> of days to a given date.  We just installed 8.19
> of Powerhouse on our HP3000.
>
> I was under the impression that this version of
> Powerhouse was Y2K compliant, but I've been
> trying to get the following code to work with no
> luck.
>
> DEFINE DT DATE CENTURY INCLUDED = &
>      20000101
> DEFINE ND DATE CENTURY INCLUDED = &
>     DATE(DAYS(DT) - 4)
>
> What happens is the ND field comes up as 0
> anytime after Jan 5, 2000 (which becomes
> Dec 21, 1999)
>
> Is this a known problem and is there a workaround?
> I've spent a long day on this and I'd appreciate
> any help anyone has to give.  ;-)
>
> -Jay Northrop
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.