Display database results between dates

Hello Wise Ones, I have an invoice table in my database with a Duedate column in this format 23-01-2020. I want to display invoice totals, paid, due, overdue, which I can do with database query and contains conditions filters, then by year and Status client side with select lists value="-2018", “-2019” and Value=“Due”, “Overdue”, Paid. But the financial year is 05-04-yyyy to 04-04-yyyy the following year. So how do I display records between dates for example 06-04-2018 to 05-04-2019? is it a ‘begins with’ and ‘ends with’ condition?

Have I explained this in a way that’s clear? its my first post.