Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] need a report with last 18 months from current....
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] need a report with last 18 months from current....
 Login/Join
 
Platinum Member
posted
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.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
    
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
 
Posts: 60 | Location: Atlanta, GA | Registered: October 30, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
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!

 
Posts: 6309 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
thanks all...


7.6.7
windows
PDF,EXCEL.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] need a report with last 18 months from current....

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.