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



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

Main Menu

Earliest Date and Latest Date in QS

Started by Cognos10x, 20 Feb 2012 11:11:35 AM

Previous topic - Next topic


Hello experts,

                     I have a requirement in which I need to compared date field to a static date
for instance I need to put a filter in the report which says  calendar.order_date<02/20/2012 and calendar.order_date>02/21/2010. How do I achieve this condition in QS ?



I'm not sure I understand completely....the condition you've written would never return any rows. A date cannot be before Feb 20 AND after Feb 21.

However, you can select the query item and filter on it. Within the "Combine Filters" dialog you can add a filter line to include additional constraints as needed.