MS Query – Date QueryLocked
I am trying to make this SQL Statment work in MS Excel Query:
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