Date Query: Next 7 Days

[basher]

I have a MySQL calendar dbase that I want to query all records within the next 7 days, a forecast of the next 7 days from the current date now().

I do not need to show a weeks range, just any records within the next 7 days, for example if the current date is Wednesday, show records on current date Wed, Thur, Fri, Sat, Sun, Mon, Tues.

The field in my table is called ddate, using the date format YYYY-MM-DD.

SELECT * FROM ltw_events WHERE ddate >= INTERVAL 7 DAY + NOW()

Doesn't do the trick 🙂

Any help would be GREAT !

[theslinky]

Try this:

SELECT * FROM ltw_events WHERE ddate >= DATE_ADD(NOW(), INTERVAL 7 DAY)

hope it works :-)

-sridhar

[basher]

I got it, here's what I came up with with some help from others.. :

SELECT DATE_FORMAT(date, '%M %d, %Y) AS date, name FROM tablename WHERE date BETWEEN NOW() AND NOW() + INTERVAL 7 DAY

I added some date formatting to the query as well.

Thanks