Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checking 2 parameters

Status
Not open for further replies.

CognosNewbie99

Technical User
Jul 13, 2011
13
US
I am writing a Cognos report which involves 2 different date fields and a status field. There is a parameter of a date range, begin date and start date. I need the report to only pull the info that has (date1 in date range) OR (date2 in date range and status = completed or closed). I put this in the query for the parameter/filter, but it does not pull the correct info. It skips the status check and only pulls in certain dates. How can I make this work?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top