[SQL] prendere solo quelli compresi nell'anno

[kodode]

Ciao a tutti!

come potrei prendere solamente i record con data compresa nell'anno?

io ho provato con:

SELECT * FROM ADA WHERE ADAdca IS NULL AND ADAatt = 1 AND ADAfin < DATE_ADD( CURDATE() , INTERVAL 365 DAY ) AND ( CURDATE() BETWEEN ADAini AND ADAfin AND ADAnii = 0 ) OR ( ADAfin > CURDATE() AND ADAnii > 0 AND ADAnid > 0 ) ORDER BY ADAfin 

e

SELECT * FROM ADA WHERE ADAdca IS NULL AND ADAatt = 1 AND ADAfin < DATE_ADD( CURDATE() , INTERVAL 11 MONTH) AND ( CURDATE() BETWEEN ADAini AND ADAfin AND ADAnii = 0 ) OR ( ADAfin > CURDATE() AND ADAnii > 0 AND ADAnid > 0 ) ORDER BY ADAfin 

non danno nessun errore però nn lo fanno...