title: SQL Date parameter for report
body: <p>I have the following table</p>
  <p><a href="https://i.stack.imgur.com/u4MZ5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/u4MZ5.png" alt="enter image description here" /></a></p>
  <pre><code>SELECT product
  FROM table
  WHERE TRY_CAST(purchased AS Date) &gt;= ’12/02/2021’
    AND TRY_CAST(purchased AS Date) &lt;= ’12/09/2021’
  </code></pre>
  <p>Running the query in SQL Server I am only getting 1 row. Date '12/09/2021' is not showing. Any idea how to fix that?</p>