However, when I select SALES.fYear2 = 2021 and SALES.Month = May. On the previous year table shows the SALES.SALES_DATE up to 05/28/2020. There are 05/31/2021. So, 31,29,30 on May are missing. I don't know what happen on my expression. It only having a issues on 05-2020
I tried to using below expression for obtain previous year date, the results look fine.