title: Using case when in Cognos data item
body: <p>I have put this in the Data Filter expression and it causes error when running the report. What I'm trying to achieve here is that when the Force Expired column has a value of Force then the action on the two other columns such as ([Policy Expiration Date] and [Policy Effective Date] should use the logic used against the current_date.</p>
  
  <pre><code>case when [Force Expired] = 'Inforce' then ([Policy Expiration Date] &gt;= current_date and [Policy Effective Date] &lt;= current_date) else end
  </code></pre>