I’m trying to run a query between dates from Mysql Database and my date format saved in data is dd-mm-yyyy
But I am getting the date of the previous year along with the searched data.
Below is my code
SELECT * FROM `msr_bills` WHERE `bill_date` BETWEEN '15-09-2021' AND '23-09-2021';
Source: Ask PHP