title: Passing date parameters to Oracle Query in SSRS
body: <p>I have an SSRS report that uses an Oracle datasource. I have a query;</p>
  
  <pre><code>select * from myTable t where
  t.date between Date '2009-08-01' and Date '2009-08-04' + 1
  </code></pre>
  
  <p>This query works, both in Oracle and from SSRS. It gets all rows from myTable when the t.date column is between 08/01/2009 and 08/04/2009. The t.date column is of type Date()</p>
  
  <p>Now, I want the dates to be parameters. So I changed the query to:</p>
  
  <pre><code>select * from myTable t where
  t.date between Date :myDate and Date :myDate + 1
  </code></pre>
  
  <p>When I run this query in SSRS, it prompts me to enter a value for :myDate. </p>
  
  <p>I tried 2009-08-01, '2009-08-01' both results in an oracle sql processing error: " Missing expression".</p>
  
  <p>Any ideas?</p>