I need to display only data with the DATEOPENED field is 7 days later. Basically todays date - 7 equals DATEOPENED. Here is my current code without date portion.
SELECT TOP (100) PERCENT ACTIONID, CATEGORY, DATEOPENED, INFO, STATUS
WHERE (CATEGORY = 'Incident') AND (INFO = 'Awaiting More Information') AND (STATUS <> OPEN)