title: comparison dates with string dd-mm-yyyy format in sqlite
body: <p>Im storing my dates as string in format 'dd-mm-yyyy'. Now I want to do a comparison like this:</p>
  
  <pre><code>SELECT strftime('%d/%m/%Y', myDate) as myDate
  FROM myTable
  WHERE myDate&gt;='01/07/2013' and myDate&lt;='24/07/2013'
  </code></pre>
  
  <p>But I get nothing. Whats wrong with this query?. </p>
  
  <p><strong>THIS IS NOT A DUPLICATE QUESTION.</strong> I was storing everything as String, no as a DATE or DATETIME. I was trying to do a comparison between strings with date format. So is not fair the down vote.</p>