Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: krunal on 22 May 2017 12:42:51 AM

Title: Date Filter
Post by: krunal on 22 May 2017 12:42:51 AM
Hi ,

I wants to show last year same month data in report studio,
so will be filter condition?


Thanks
Title: Re: Date Filter
Post by: BigChris on 22 May 2017 02:19:23 AM
Is your data relational or dimensional?
Title: Re: Date Filter
Post by: hespora on 22 May 2017 03:15:12 AM
Code Select

[whateveryourdatefieldiscalled] between
_first_of_month(_add_years(current_date,-1)) and _last_of_month(_add_years(current_date,-1))


in case of relational.
Title: Re: Date Filter
Post by: krunal on 22 May 2017 07:29:10 AM
my report is relational

Thanks Hespora,
Title: Re: Date Filter
Post by: hespora on 23 May 2017 02:30:22 AM
you're welcome; glad I could help :)
Text only | Text with Images