title: Search Between Date in Query is not showing the correct Result
body: <p>I'm trying to run a query between dates from Mysql Database and my date format saved in data is <strong>dd-mm-yyyy</strong></p>
  <p>But I am getting the date of the previous year along with the searched data.</p>
  <p>Below is my code</p>
  <p><code>SELECT * FROM `msr_bills` WHERE `bill_date` BETWEEN '15-09-2021' AND '23-09-2021';</code></p>