Print Page - To display last 30 days data from the Current Date in my Report

Title: To display last 30 days data from the Current Date in my Report
Post by: fshahul on 23 Feb 2014 04:36:25 AM

Hi,

Can anyone please help me on "how can I filter last 30 days data from the Current Date. I just want to see the data for last 30 days from the Current Date.

Environment: Cognos 10.1.1 Report Studio
Database: Oracle
Package: relational

Its very urgent

Thanks.

Title: Re: To display last 30 days data from the Current Date in my Report
Post by: BigChris on 24 Feb 2014 02:13:42 AM

[Query].[Date] >= _add_days(getdate(),-30)

Title: Re: To display last 30 days data from the Current Date in my Report
Post by: MFGF on 24 Feb 2014 01:33:37 PM

Thanks, Chris, for replying to this urgent request. I'm sure fshahul is very grateful :)

MF.

Title: Re: To display last 30 days data from the Current Date in my Report
Post by: Lynn on 24 Feb 2014 03:29:13 PM

Quote from: MFGF on 24 Feb 2014 01:33:37 PM
Thanks, Chris, for replying to this urgent request. I'm sure fshahul is very grateful :)

MF.

Seems there are too many posters who have time to post their urgent questions but not enough time to post back with a quick thank you.

Title: Re: To display last 30 days data from the Current Date in my Report
Post by: BigChris on 25 Feb 2014 02:19:29 AM

Just glad to be able to help. Any thanks that come back are gratefully received...but generally I don't expect any so it's a nice surprise when they do.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: fshahul on 23 Feb 2014 04:36:25 AM