Please disregard, I found my answer on this site:

http://www.sqlservercentral.com/scripts/contributions/865.asp

Thanks!

Sorry if this is redundant but here goes:

I would like to use a query like this to return all rows where date field falls into "Last full week".. i.e. if...