title: Sqlite3 select between from not standart date format
body: <p>I have a table with <code>Date</code> column with type <code>DATE</code> where values is looks like: <code>'%d.%m.%Y'</code>. How I can get rows for current month? I already tried: </p>
  
  <pre><code>SELECT *
  FROM SampleTable
  WHERE Date BETWEEN strftime('%d.%m.%Y', date('now','start of month')) AND
      strftime('%d.%m.%Y', date('now','start of month','+1 month','-1 day'))
  </code></pre>
  
  <p>But then I get all rows. I would be grateful for any help.</p>