title: How to query dates range using peewee?
body: <p>I have SQLite database with tables that contains dates. I want ot select records that falls in particular range, but I fail to write correct query.</p>
  
  <pre><code># This query returns nothing
  rows = model.select().where(  
                   (model.date.between(start_date, end_date)) &amp; 
                   (model.name == point_name)
           ).tuples()
  
  
  # This query returns nothing too
  rows = model.select().where(  
                   (model.date &gt; start_date) &amp;
                   (model.date &lt; end_date) &amp;
                   (model.name == point_name)
           ).tuples()
  
  
  # However tis one works:
  rows = model.select().where(  
               (model.date &gt; start_date) &amp;
               (model.name == point_name)
           ).tuples()
  </code></pre>
  
  <p>Why my code is working when query dates that are either begger or smaller than the given and fails when I try to query range of dates?</p>