-DEFAULT &STARTDATE = '2014/10/20';
-DEFAULT &ENDDATE = '2014/10/27';
-*-DEFAULT &DIVISION = '1D' ;
-*-DEFAULT &SUB_ASG = 'SHIFT 1' ;
-TYPE STARTDATE = &STARTDATE
-TYPE ENDDATE = &ENDDATE

-SET &BEG_DATE_ISSUED = &STARTDATE | ' 00:00:00.000';
-SET &END_DATE_ISSUED = &ENDDATE | ' 00:00:00.000'; 

quote:

Originally posted by Wep5622:
It does, but with -DEFAULT you need to .EVAL the value (safe in this case) as it does not evaluate expressions of its own accord.
And it's -SET and -DEFAULT, not SET and DEFAULT. Those are different languages!

But of course you can't just subtract 7 from a numerical date value like Prarie suggested, that will only work after the 8th of each month.

You'll need to calculate the date using the "smart date" functions (DATECVT and DATEADD in this case). Be aware that dialog manager (which the -SET command is part of) does not understand "smart dates", so you'll have to convert it back to something simpler: number or string.

Or you do the calculations in a DEFINE or COMPUTE block in your TABLE request. That's FOCUS code and it does understand "smart dates".

BTW, I think you got your explanation backwards. I assume you meant to set the ENDDATE to the current date and the STARTDATE 7 days ago, otherwise you create a time range that is -7 days long.