title: Need to get dates between last April and next March in MySQL
body: <p>Exclusively in MySQL, I need to get the date for <code>last April</code> and <code>next March</code>.</p>
  <p>This is easy in PHP as the DateTime functions literally allow you to enter <code>last April</code> and it will give you a date.</p>
  <p>I want to select records where their date is between 01-04-2021 and then 31-03-2022 – BUT, when the 1st of April 2022 comes around, I need it to automatically change to 01-04-2022 and 31-03-2023.</p>