I have inherited a database and we currently have a query that pulls all invoices that were completed last week. I wanted to add another report that does the same thing for the last 4 weeks starting as of today. This will help audit anything missed. The code I have appears to only use Static...