Hiya guys

I need to produce a mysql statement that returns all records between two dates, the first of which being the current date, the second of which being in 7 days time, now i know i can use the date_add function to get the exact date of the second value, but how would the mysql query be structured?

Thanks Dudes (