Return rows for the next week

[rubing]

I am trying to return all rows in the range of this upcomming week. So, I am using CURDATE() and (CURDATE() + 7).  Unfortunately it is not working.  Is there something wrong with this query?

 

 

SELECT DISTINCT MusicEvents.Band, Venue, BandSite, Category, HomeTown 
FROM MusicEvents LEFT JOIN Bands ON MusicEvents.Band=Bands.Band 
WHERE Date BETWEEN CURDATE() and (CURDATE() + 7) 
ORDER BY Venue ASC, Source ASC, MusicEvents.Band ASC

[fenway]

There is... 7 what?

 

WHERE Date BETWEEN CURDATE() and (CURDATE() + INTERVAL 7 DAY)