I have a query that I need it to give me data for the last full week.
I have this working in Access but the syntax must be different in Excel.
I know I could use parameters, but want little intervention from users.
Anyone show me the correct way.
Using Office 2k, querying DB2 database
Thanks,

Glenn
This is what I use in Access.
 ((Format([SHARE]![CLOSE_DATE],"wwyy"))=Format(DateAdd('ww',-1,Date()),"wwyy")))