Hi,
Is there a way to save the current date on the file name every time a ReportCaster job is run? I'd prefer to use Excel format but if it has to be in another format, that would work too.

Thanks for your help!

This message has been edited. Last edited by: Kerry,

Try something like this in your program code. You may need to add specific APP folder or other directory location information to the front of the file name.

-SET &OUTFILE  = 'REPORT_' || &YYMD || '.xls';
-*
APP FILEDEF RPTFILE DISK &OUTFILE
-*
TABLE FILE xxx
 PRINT/SUM ...
 BY ...
 WHERE ...
 ON TABLE HOLD AS RPTFILE FORMAT EXL2K
END