title: rodbc date filter
body: <p>I have been trying to set a query to a MS SQL database through RODBC. Unfortunately I cannot set appropriate date filters. I tried typing date in quotes and single quotes, DATE function, brackets and it doesn't want to work.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>    dbquery &lt;- sqlQuery(dbhandle, 'SELECT ST03001, ST03003, ST03007, ST03015, ST03012, ST03020, ST03021, ST03022 
      FROM deh_10.dbo.ST031000 ST031000 
      WHERE (ST03015&gt;'2013-01-01')')
  </code></pre>
  
  <p>I usually get this error message:</p>
  
  <pre><code>    "dbquery &lt;- sqlQuery(dbhandle, 'SELECT ST03001, ST03003, ST03007, ST03015, ST03012,
       ST03020, ST03021, ST03022 FROM deh_10.dbo.ST031000 ST031000 WHERE
       (ST03015&gt;DATE('2013"
  </code></pre>
  
  <p>After the date filter I have several other filters separated from each other by OR (excluded from the example).</p>