Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 days

Summary:

I am trying to generate reports on Opportunities Created or modified in last 7 days - or "Last Week".

Also, I want to do the same with Contacts and Accounts created or modified in the same time period

Content (required):

I tried to use a query like -

TIMESTAMPDIFF( SQL_TSI_DAY , Last Updated Date, CURRENT_DATE ) is equal to / is in 7

but it is not working

UPDATE - I did some more research and found a couple resources

And

Version (include the version you are using, if applicable):

I updated is less than or equal to 7

And that seems to work