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
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.