Focal Point
[SOLVED] need a report with last 18 months from current....

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/866101794

July 28, 2010, 10:36 AM
swati
[SOLVED] need a report with last 18 months from current....
Hi all,
i have a report in which i need the data related to last 18 months from current date.
can somebody please help me the date function i have to use.


i know this is for 12 months i.e; 1 year

WHERE LINE_POSTED_DATE LE DATEADD('CY_DATE', 'Y', -1);
(where CY_DATE is the current date)

how can i modify the above for making it work for 18 months,i.e;1.5 year.

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


7.6.7
windows
PDF,EXCEL.
July 28, 2010, 10:56 AM
GinnyJakes
Do this at the beginning of your fex and use the amper variable in your WHERE clause.
-SET &MONTH_18=AYM(&YYMD,-18,'I6YYM');



Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
July 28, 2010, 01:11 PM
mrguru
    
WHERE LINE_POSTED_DATE LE DATEADD('CY_DATE', 'M', -18);




WF 8.2.01M
8.2.01M Reporting Server
Windows 2012 Srvr R2
PDF,Excel, HTML
Graphs - a lot of graphs
July 28, 2010, 06:01 PM
Waz
Two things...

1. What is the format of the field. Is it Date or Date time.

2. Should your test be WHERE LINE_POSTED_DATE GE. Or a range.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 02, 2010, 09:34 AM
swati
thanks all...


7.6.7
windows
PDF,EXCEL.