If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need help with time based report filter

Started by gronhoffga, 23 Nov 2009 07:34:54 AM

Previous topic - Next topic

gronhoffga

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

tiga123

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]

billylodz

_age([time])=0

or
_days_between([time],current_date)=0