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,
Do this at the beginning of your fex and use the amper variable in your WHERE clause.
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
WHERE LINE_POSTED_DATE LE DATEADD('CY_DATE', 'M', -18);
8.2.01M Reporting Server
Windows 2012 Srvr R2
Graphs - a lot of graphs
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.
|Powered by Social Strata|