[nn.nn]

SELECT * FROM table WHERE date > DATE_ADD(CURDATE(), INTERVAL -5 DAY) and DATE < DATE_ADD(CURDATE(), INTERVAL 15 DAY);