[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.