title: Search By Date in SQL Server 2012
body: <p>We just upgraded to SQL Server 2012 from 2005.  While I'm a novice, something this simple couldn't be this difficult.  I used to be able to pull data from a table based on the date vs date and time.  As it now stands I have:</p>
  
  <pre><code>Select * from receipts_table where receipt_cancel_date = '2013-09-20'
  </code></pre>
  
  <p>before we upgraded this would work fine.  How can I run this and actually get the desired results as I know there's receipts with a cancel date of 2013-09-20.</p>
  
  <p>Thanx</p>