Validating Date Prompt To be less than Current Date OBIEE
<p>I have a requirement to create two validations on the date prompt:</p>

<p>1) The From Date has to be less than To Date</p>

<p>2) The To Date has to be less than or equal to current date</p>

<p>I created a conditional analysis wherein From Date is &lt; To Date, which works, but when I try to create an advanced filter wherein @To_Date &lt;= Current_Date I am getting an error. </p>

<blockquote>
  <p>Error getting drill information: SELECT date'2016-08-24' saw_0 FROM "Workforce Management - Processed Time Cards Real Time" WHERE(date'@{To_Date}' &lt;= (SELECT VALUEOF("CURRENT_DATE_REP_OTBI") FROM "Workforce Management - Processed Time Cards Real Time" FETCH FIRST 1 ROWS ONLY))</p>
</blockquote>

<p>If anyone can help solve this, it'd be really helpful! 
Thanks</p>