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.

if you want dates in a range then simply use is greater than or equal to start date AND less then or equal to end date within your query

i.e. mydate >= ‘06-04-2018’ AND mydate <= ‘05-04-2019’

1 Like