Subject: | |
From: | |
Reply To: | |
Date: | Mon, 30 Dec 1996 14:20:42 -0800 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
The DATE function you are using returns a 6 or 8 digit result
depending on the setting of the CENTURY INCLUDED/EXCLUDED option
in the dictionary. If set to CENTURY EXCLUDED, it returns a 6 digit
date. It sounds like the option in the dictionary was changed from
INCLUDED to EXCLUDED since you last ran the report.
--Ken Kirby
Vanderbilt University
-----------------------------------------------------------------------
Harrington, Don wrote:
>
> Gang;
>
> I have a QUIZ extract that uses a LOT of QUIZ DATE functions. This
> report worked three months ago and has
> not been changed since. Now, for some reason, the following statement
> generated strange output.
>
> DEFINE WEEK57-DT DATE CENTURY INCLUDED PIC "^^^^^^^^" =
> DATE(WEEK57-DAYS)
>
> WEEK57-DAYS = 35767
>
> WEEK57-DT ends up as 971204 instead of 19971204.
>
> So, when I put this into an eight character string using ',8', it ends
> up as 00971204.
>
> Headquarters is breathing down my neck, so any help would be greatly
> appreciated.
>
> Thanks,
>
> Don Harrington 206-931-4457 (V - Auburn) 206-931-9085 (F - Auburn)
> The Boeing Company 206-645-2591 (Alpha Pager)
> PO Box 3707 M/S 5J-34 206-544-7429 (V - South Park)
> Seattle, WA 98124-2207 206-544-5820 (F - South Park)
> [log in to unmask]
|
|
|