how to get last full 12 month in beast mode
I would like to create a flag for the date for the last 12 full months, not including the current month. For example, as of now, I only want to show any dates are in Oct 2018 to Nov 2017. I used this one, but give me to the same date of last year.
DATE_SUB(now(), INTERVAL 12 MONTH)