[CLOSED] 7 last days from currently day

December 17, 2014, 09:33 AM

Hi Folcs,

I'm trying to develop a report tha return values from the last 7 days from the day before of currently day.

Ex. today is 17/12/2014 (dd-mm-yyyy), the report must return values from 10/12 to 16/12.

The aim is not to insert manualy the start day and the last day.

Thanks in advance

This message has been edited. Last edited by: <Kathryn Henning>,

WebFOCUS 8.0.06
Windows, All Outputs

December 17, 2014, 10:22 AM

Prarie

 DEFINE FILE CAR
TODAY/MDYY = '&DATEMDYY';
WEEK/MDYY = TODAY - 7;
END
TABLE FILE CAR
PRINT CAR
TODAY WEEK
END

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

December 17, 2014, 10:33 AM

jfr99

Here's an example ...

-* SET CURRENT DATE
-SET &CUR_YYMD = &YYMD;
-*
-SET &BEG_YYMD = DATECVT((DATEADD((DATECVT (&CUR_YYMD, 'I8YYMD', 'YYMD')),'D', -7)), 'YYMD','I8YYMD');
-SET &END_YYMD = DATECVT((DATEADD((DATECVT (&CUR_YYMD, 'I8YYMD', 'YYMD')),'D', -1)), 'YYMD','I8YYMD');
-*
-SET &BEG_DATE = FPRINT(DATECVT(DATECVT(&BEG_YYMD,'I8YYMD','YYMD'),'YYMD','DMYY'),'DMYY','A10');
-SET &END_DATE = FPRINT(DATECVT(DATECVT(&END_YYMD,'I8YYMD','YYMD'),'YYMD','DMYY'),'DMYY','A10');
-*
-TYPE -------------------------------------------------
-TYPE CURRENT YYMD (CUR_YYMD) ------ &CUR_YYMD
-TYPE -------------------------------------------------
-TYPE BEGIN YYMD (BEG_YYMD) ------ &BEG_YYMD
-TYPE END YYMD (END_YYMD) ------ &END_YYMD
-TYPE -------------------------------------------------
-TYPE BEGIN DATE (BEG_DATE) ------ &BEG_DATE
-TYPE END DATE (END_DATE) ------ &END_DATE
-TYPE -------------------------------------------------
-EXIT

WebFocus 8.201M, Windows, App Studio