DATE_ADD sytax

[John Dillon]

SELECT myfield FROM Bookings WHERE date_field<='2004/10/09' && DATE_ADD('2004/10/01',INTERVAL(7 day))>='2004/10/09'

- or if I use MyDateField instead of '2004/10/01' - fails with :

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'day))>='2004/10/09'' at line 1

Can anyone see why? I want to add a variable number of days to a date within the WHERE part of the query.

John