In the Selection Criteria is it possible to setup a constant or parameter to get data for 1 week, 2 weeks ago from current date?

I am a new to this.

I know I can put in a parameter for begindate and one for enddate that will prompt and end user for the dates, but I am looking to automate this report on a weekly bases using Report Caster.

Thanks for your help.

Use &YYMD as the current date. Then use function AYMD to subtract 14 days from the current date to get your begin date. Use &YYMD as your end date.

-SET &BEGDATE=AYMD(&YYMD,-14,'I8YYMD');
TABLE FILE filename
PRINT ...
WHERE FILEDATE GE &BEGDATE AND FILEDATE LE &YYMD
END