You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Accepted answer
edited Dec 11, 2022 4:38PM in Reporting & Analytics for Sales 3 comments


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


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

I updated is less than or equal to 7

And that seems to work

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!