COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gronhoffga on 23 Nov 2009 07:34:54 AM

Title: Need help with time based report filter
Post by: gronhoffga on 23 Nov 2009 07:34:54 AM
I need to make a report that shows items that were created TODAY only, for example if it is the 23rd then the report should show only items created on the 23rd, for the 24th only items on the 24th etc. I have all the fields I need for the report itself but cannot figure out how to create the filter that provides the above function.

Thanks
Title: Re: Need help with time based report filter
Post by: tiga123 on 23 Nov 2009 08:56:36 AM
add a query item to your query. put in the query item: current_date

then add a filter to your query where [create_date] = [current_date]
Title: Re: Need help with time based report filter
Post by: billylodz on 23 Nov 2009 09:04:47 AM
_age([time])=0

or
_days_between([time],current_date)=0