Quiz Explanation Requested
Ohmes, Matt
Matt.Ohmes@COGNOS.com
Thu, 28 Mar 2002 17:28:35 -0500
Looking at the following code:
DEFINE START-DATE DATE CENTURY EXCLUDED = &
PARM PROMPT "ENTER START DATE (YYMMDD):"
DEFINE NEW-DATE DATE CENTURY EXCLUDED = &
REMOVECENTURY(DATE(DAYS(DT-DAYS-DATE-K2) + 364))
DEFINE MYDT CHAR*4 = ASC(NEW-DATE,6)
DEFINE MY-CHRON-SEQ NUM = DAYS(NEW-DATE)
DEFINE MY-DT-DAYS-DATE-K2 DATE = REMOVECENTURY(NEW-DATE)
SELECT IF DT-DAYS-DATE-K2 GE START-DATE
It seems that DT-Days-Date-K2 includes a century and Start-Date does not.
Have you tried reporting Dt-Days-Date-K2?
Just a thought.
Matt
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.