I have a report in which I have the current date stored in a variable, and I want to include it as field on the report. I tried this:

-SET &WORKDATE = AYMD(&YYMD,0,'I8YYMD') ;
-SET &SAVEDATE=EDIT(&WORKDATE,'99999999$');
.....
.....
BY
	'&SAVEDATE'  AS 'Date Rpt Run'

I also tried:

BY
	&SAVEDATE  AS 'Date Rpt Run'

Both give me

 (FOC003) THE FIELDNAME IS NOT RECOGNIZED: 20140430
    BYPASSING TO END OF COMMAND

What is the proper syntax for including a variable in the report? Output of the report is Excel, if that matters.

This message has been edited. Last edited by: Josh K,

Hi Josh,

Does this help?

-*
-SET &WORKDATE = AYMD(&YYMD,0,'I8YYMD') ;
-*
DEFINE FILE CAR
RUN_DATE1/MDYY = &MDYY;
RUN_DATE2/YYMD = &WORKDATE;
END
-*
TABLE FILE CAR
HEADING
"WORKDATE = &WORKDATE "
" "
PRINT
RUN_DATE1
RUN_DATE2 AS 'Date Rpt Run'
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL07
END

Josh, I assume this is a static value to be shown in the report.

If so you need to define the field first.

DEFINE FILE CAR
 SAVEDATE/I8 = &YYMD ;
END 
TABLE FILE CAR
PRINT MODEL
BY SAVEDATE
BY COUNTRY
BY CAR
END  

Thanks!