title: Can't Import Data in Condition of Date with read.csv.sql
body: <p><strong>Environment:</strong> R</p>
  
  <p><strong>Goal:</strong> import all data from a csv where Start Date is before 10/1/2013</p>
  
  <p><strong>Data Structure:</strong> </p>
  
  <pre><code>Trip ID Duration    Start Date  Start Station
  
  4576    63  8/29/2013 14:13 South Van Ness at Market
  
  4607    70  8/29/2013 14:42 San Jose City Hall
  
  4130    71  8/29/2013 10:16 Mountain View City Hall
  
  4251    77  8/29/2013 11:29 San Jose City Hall
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/b4VmZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b4VmZ.png" alt="enter image description here"></a></p>
  
  <p><strong>Code:</strong></p>
  
  <pre><code>library(sqldf)
  tripData &lt;- read.csv.sql("201402_trip_data.csv", sql = "select * from file where 'Start Date' &lt;= '10/1/2013'",header = TRUE, eol = "\n")
  </code></pre>
  
  <p><strong>Question:</strong></p>
  
  <p>There's no warnings in R, but the result shows that only 11 variables name were imported, but no observation in the tripData.</p>