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

Author Topic: Earliest Date and Latest Date in QS  (Read 7385 times)

Offline Cognos10x

  • Full Member
  • ***
  • Join Date: Jan 2012
  • Posts: 19
  • Forum Citizenship: +0/-0
Earliest Date and Latest Date in QS
« on: 20 Feb 2012 11:11:35 am »
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

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,702
  • Forum Citizenship: +342/-1
Re: Earliest Date and Latest Date in QS
« Reply #1 on: 21 Feb 2012 07:38:18 am »
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.