COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rr.bi1212 on 27 Apr 2012 11:50:29 AM

Title: How to implement this filter?
Post by: rr.bi1212 on 27 Apr 2012 11:50:29 AM
Hi,

  I need to put the below filter in report studio


death date is NULL or <= 2008-01-01


Thanks in Advance
Title: Re: How to implement this filter?
Post by: FirstStruck on 27 Apr 2012 12:29:58 PM
replace NULL with missing and add death date again after the or:

Death Date is missing or Death Date <= 2008-01-01