title: Automatic filter for current month and year in Cognos Report Studio ver 10
body: <p>I have a query item which filters records by a date column which is in format <code>'YYYYMM</code>'. As of now I have hard coded the value <code>[DateCol] = '201406'</code> in <code>Detail filters</code> to get the current month and year records. But I want to dynamically have this value change. For next month it should filter records by '201407'. How do I achieve this?
  I tried this by dragging the <code>[DateCol]</code> in a <code>Detail filters</code>:</p>
  
  <pre><code>[DateCol] = extract(year, current_date) + extract(month, current_date)
  </code></pre>
  
  <p>But it returned an error:</p>
  
  <pre><code>UDA-SQL-0460 The operation "equal" is invalid for the following combination of data types: Character and Integer
  </code></pre>
  
  <p>Please guide</p>