title: Date Picker Parameter for Oracle Apex Interactive Report
body: <p>I want to make an interactive report which as one parameter (a date picker),based on the date selected I want to load/refresh my interactive report respectively and the datepicker item will be submitted to load report.</p>
  
  <p>I have already tried by submitting the datepicker item,used Dynamic Action to Set its event to "change" then set it's true action to "submit page".But No result is displayed.</p>
  
  <p>Here is my report query:</p>
  
  <blockquote>
    <p>select * from TRN_SUMMARY  where (:P2_DATE IS NULL) OR to_char(REP_DATE,'DD-MON-YYYY')=:P2_DATE;</p>
  </blockquote>