risolto..la WHERE č cosi composta

codice:
SELECT * FROM TABELLA WHERE data BETWEEN [oggi] AND [oggi] + INTERVAL 15 DAY