title: cannot get subset of date from df based on date columns
body: <p>I am making a report about a data frame containing transactions for parking. The data frame has two POSIXct variables called <strong>start_time</strong> and <strong>end_time</strong>. An example of how they look is this:</p>
  
  <p><code>2019-11-25 10:35:00 UTC" "2019-11-28 18:21:00 UTC"</code> </p>
  
  <p>I want to get a subset of my data frame from <code>"2020-02-06"</code> till <code>"2020-03-23"</code>.
  There are definitely transactions that occurred during this time but when I use the following code I get a subset with zero observations.</p>
  
  <pre><code>cutdate&lt;- as.Date("2020-03-23",format ="%Y-%m-%d")
  bdate&lt;-as.Date("2020-06-02",format ="%Y-%m-%d")
  
  dwdf%&gt;% filter(as.Date(start_time) &gt;= bdate &amp; as.Date(end_time) &lt; cutdate)-&gt;Bdf
  </code></pre>
  
  <p>I have tried other functions like subset and so forth but I get the same thing. I then tried something simpler and tried to see if from the variable <strong>start_time</strong> if I created a simple boolean expression like</p>
  
  <pre><code>any(as.Date(dwdf$start_time) &gt; bdate)
  </code></pre>
  
  <p>If I would get any TRUE's but all I get is <em>false</em>. I do not understand why this is the case because if I do <code>range(start_time)</code> 
  There are clearly start times that are later than february 6th.</p>
  
  <p>I have also looked at similar questions on stack exchange and I don't know why I am getting different results since I am implementing what they said.</p>