I am using sql server 2008 R2 and am trying to extract new invoice items that are added to my database. I wanted to be able to pull any item that was invoiced this week, but not in 'X' number of previous weeks...Any help would be appreciated...Thanks