I know this is more of a SQL question, but I'm having trouble getting EE to cooperate. I have entries that expire, and want to show only entries which have expired in the last 12 months. I tried:
SELECT entry_id, title, expiration_date FROM exp_channel_titles WHERE expiration_date BETWEEN date_sub(Now(), INTERVAL 12 MONTH) AND Now();
I get zero results.