Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 days — Cloud Customer Connect
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
13
Views
1
Comments
edited Dec 11, 2022 4:38PM in Reporting & Analytics for Sales 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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