title: Creating Subsets of data with multiple where/between statements
body: <p>I have a dataset which consists of 2 days in 2 different months and the same time periods. It shows how many occupants were in a house during the time. I want to separate the data by date, time period AND houseid.</p>
  
  <p>So i want to get all the records where the date is 01-02-2010, between the time periods 14:00:00 - 19:00:00 where houseid is N60421A. At the moment data.type is stored as characters except for occupants which is numeric.</p>
  
  <p><a href="http://www.sharecsv.com/s/aa6d4dc34acfbaf73ada1d2c8764b888/modecsv.csv" rel="nofollow">http://www.sharecsv.com/s/aa6d4dc34acfbaf73ada1d2c8764b888/modecsv.csv</a></p>
  
  <p>Atm i have tried this but i seem to get no results</p>
  
  <pre><code>data2 = subset(data, dayMonthYear == "01/02/2010" &amp;&amp; Houses == "N60421A")
  </code></pre>
  
  <p>In SQL i would do something like</p>
  
  <pre><code>SELECT *
  From data
  where dayMonthYear == "01/02/2010"
  AND houses == "N60421A"
  AND time &gt; 14:00:00
  AND time &lt; 19:00:00
  </code></pre>