-DEFAULTS &FIRSTMON=20121201
DEFINE FILE CAR
MYDATE/YYMD WITH COUNTRY = '&FIRSTMON' ;
DOW/I1 = MYDATE - (INT(MYDATE/7) * 7) ;
MYSAT2/YYMD = IF DOW LE 5 THEN MYDATE+12-DOW ELSE MYDATE+14+DOW ;
END
TABLE FILE CAR
PRINT MYDATE DOW MYSAT2
IF RECORDLIMIT EQ 2
END
e.g.
EX TEST FIRSTMON=20121201
for dec, 2012
IBI Development
December 14, 2012, 07:41 AM
Deepu
quote:
Originally posted by Waz: It should be a simple calc to get the day of week for the first day of the month and add 1 week + x days to it.
Thanks waz Its working fine One need a information how to find the last run date report time , I'm not using Report Caster ,I'm running report manually
WebFOCUS 7.6 Windows, All Outputs
December 16, 2012, 03:47 PM
Waz
The simplest way to get the previous run would be to capture then run date each time the report is run, save it to a DB, FOCUS or other, then just TABLE to get the date/time.