COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sarkar on 02 Dec 2008 10:28:36 AM

Title: 3 months before data
Post by: Sarkar on 02 Dec 2008 10:28:36 AM
Hi Friends,

             How to get 3 months before data in Report Studio When user selects
             year. If any body know please provide me hint or solution .
             Thanks in advance
Title: Re: 3 months before data
Post by: Suraj on 02 Dec 2008 11:30:01 AM
use expression similar to below for your date filter.
add_months({sysdate},-3)