I am trying to get the dateJoined field to be between 1 year ago and 2 years ago. In other words, BETWEEN 2004-01-10 AND 2003-01-10
It works fine if I put those literals in but not with the DATE_SUB funciton. I CAN , however, add the DATE_SUB functions in the select fields to display and they show up correctly.
WHERE language = ‘en’
BETWEEN DATE_SUB( CURDATE(),INTERVAL 12 MONTH)
AND DATE_SUB( CURDATE(),INTERVAL 24 MONTH)