title: OBIEE11g date manipulation/comparison via the advanced SQL filter
body: <p>I'm running into an issue in Analysis with the Advanced SQL Filter and date comparisons. </p>
  
  <p>I have two date fields, <code>Report Date</code> and <code>Validated Date</code>. I'm doing a comparison in the Advanced SQL Filter where these two dates should match.</p>
  
  <p>In this case, the <code>Report Date</code> is <code>28-FEB-2012 12:00</code> and the <code>Validated Date</code> is <code>28-FEB-2012 20:00</code>.  My analysis says these two dates are equal.  Except technically, they are not. </p>
  
  <p>Expressed in SQL, I'm trying to accomplish this:</p>
  
  <pre><code>TO_CHAR(REPORT_DATE, 'DD-MON-YYYY') = TO_CHAR(VALIDATED_DATE, 'DD-MON-YYYY')  
  </code></pre>
  
  <p>I've tried that line in the advanced SQL filter and it's not working. I've tried:</p>
  
  <pre><code>EVALUATE(to_date(%1, %2), REPORT_NAME, 'DD-MON-YYYY')
  </code></pre>
  
  <p>...and OBIEE is not accepting it.</p>
  
  <p>So, OBIEE 11g gurus, how do I properly compare these dates so it's clear that they do not match?</p>