Getting data from Current Month backwards as Past Due and Future
I am trying this code but still cannot get data from previous month from last year 2024. All I got in "Past Due" is data from current month (January) and in "Future" I get all the data from future month plus from last year CASE WHEN MONTH(`SSD`)<=MONTH(CURRENT_DATE())AND YEAR(`SSD`)<=YEAR(CURRENT_DATE()) THEN 'Past Due'…
