[SOLVED] DATE_SUB(curdate(), INTERVAL 7 DAY) pulling next years data

[drranch]

I ran the following query in MYSQL and its returning next yeards records...

 

SELECT follow_up_date, DATE_FORMAT(follow_up_date, '%b %d, %Y') AS fdateformat, nick_name FROM showing WHERE follow_up_date >=DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND username='{$_SESSION[loginUsername]}' ORDER BY follow_up_date DESC

 

Any one know why?

[drranch]

SELECT follow_up_date, DATE_FORMAT(follow_up_date, '%b %d, %Y') AS fdateformat, nick_name FROM showing WHERE follow_up_date BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND username='{$_SESSION[loginUsername]}' ORDER BY follow_up_date DESC