Hello again. I would like to have my report display the dates of the data that is in the file. Example: I'm using a file that has current quarter data in it. I would like the header to show "DATA THROUGH: 10/1/04 to 12/03/04". The data is separated by month. When I tried using the MIN and MAX prefixes I only got the dates for my last month, 12/01/04 to 12/03/04, not the dates for the complete dataset. Here's my query:
00001 DEFINE FILE EXFDAILY
00002 MONTH/M=RECVDATE;
00003 MONTH3/A3=DECODE MONTH('10' 'OCT' '11' 'NOV' '12' 'DEC');
00004 END
00005 TABLE FILE EXFDAILY
00006 SUM TOTPCS FAILPCS
00007 COMPUTE ONTIME/D6.2=(TOTPCS-FAILPCS)/TOTPCS*100;
00008 IF DDISTCODE EQ '800'
00009 IF SERV EQ 1
00010 BY MONTH3
00011 HEADING CENTER
00012 "EXFC SCORE BY MONTH"
00013 "DATA THROUGH: </1"
00014 END

Any ideas?

Thanks Mike

TABLE FILE EXFDAILY
SUM MIN.RECVDATE MAX.RECVDATE
ON TABLE SAVE AS DATES
END
-RUN
-READ DATES &MINDATE.A8. MAXDATE.A8,
TABLE FILE EXFDAILY
HEADING
"Dates from &MINDATE to &MAXDATE "
...

The length of the dates will depend on the formats. You may also want to use -SETs to add the slashes.

Thank you. That worked great. Interesting concept, I never thought of using a table that way.

Mike