title: Finding a Specific Date with SQL
body: <p>I'm trying to search in an database for records with a specific date. I've tried to search in the following ways:</p>
  
  <pre><code>SELECT * 
  FROM TABLE_1
  WHERE CAL_DATE=01/01/2015
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * 
  FROM TABLE_1
  WHERE CAL_DATE='01/01/2015'
  </code></pre>
  
  <p>I'm working with an Access database, and in the table, the dates are showing in the same format (01/01/2015). Is there something I'm missing in the SQL statement? </p>