title: SQALCHEMY query between two dates
body: <p>I looked at that link</p>
  
  <p>It's weird because the query im doing is hit and miss.
  It can't show the dates if the difference is only a few days</p>
  
  <p><a href="https://stackoverflow.com/questions/8895208/sqlalchemy-how-to-filter-date-field">SQLAlchemy: how to filter date field?</a></p>
  
  <p>model:</p>
  
  <pre><code>class UserCallsModel(db.Model):
      id = db.Column(db.Integer, primary_key = True)
      date = db.Column(db.String(90))
      username = db.Column(db.String(90))
      event_name = db.Column(db.String(90))
  </code></pre>
  
  <p>query:</p>
  
  <pre><code>users = UserCallsModel.query.filter(UserCallsModel.date.between("2016-1-1",  "2016-1-20")).order_by(UserCallsModel.date.desc())
  </code></pre>
  
  <p>I've got 2 dates that fall within this range but is not getting queried?</p>