MS Query – Date Query

Hi

I am trying to make this SQL Statment work in MS Excel Query:

dateadd(DAY,-7,getdate())

or a simular query that will work, so that i can pull all information based on todays date -7 days using the date field.

I have tried inserting the above query directly into the SQL option of MS Query but it returns that getdate() is an unregconised statment.

Thanks in advance

Kind Regards