select date 7 days from today

[Syl]

Hi group -

I have a table with a date field:
eventdate date

I need to select all records where the eventdate is 7 days from today.

Any ideas ? I've been looking at diffdate but I don't think I'm on the
right track.

Thanks!

[Steve]

Re: select date 7 days from today


SELECT *
FROM mytable
WHERE DATE_ADD( CURDATE(), INTERVAL 7 DAY ) = eventdate

---
Steve

[Syl]

Re: select date 7 days from today

Terriffic! tested and works great.
Thanks so much Steve.

It's easy once you know how! ;-)