Sql not working: BETWEEN DATE_SUB( CURDATE(),INTERVAL 12 MONTH)

Databases
1

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.

Any ideas?

SELECT COUNT(MID)
FROM table1
WHERE language = ‘en’
AND dateJoined
BETWEEN DATE_SUB( CURDATE(),INTERVAL 12 MONTH)
AND DATE_SUB( CURDATE(),INTERVAL 24 MONTH)

2

have you tried it like this –

… BETWEEN DATE_SUB( CURDATE(),INTERVAL 24 MONTH)
AND DATE_SUB( CURDATE(),INTERVAL 12 MONTH)