Earliest Date and Latest Date in QS

[Cognos10x]

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 ?

Thanks

[Lynn]

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.