Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: archanacg1 on 24 Feb 2018 02:11:56 PM

Title: date condition
Post by: archanacg1 on 24 Feb 2018 02:11:56 PM
Hi,
I am new to cognos and trying to pull all the ids greater than file_cre_ts. file_cre_ts includes date and time.  not sure how to put this in cognos

current date - trunc(file_cre_ts) > 90.


please suggest
Title: Re: date condition
Post by: hespora on 26 Feb 2018 02:21:56 AM
Code Select

[file_cre_ts] > _add_days(current_date,-90)
Text only | Text with Images