1 Reply Latest reply: Aug 20, 2012 4:41 AM by dpl007 RSS

    Show all companies with no activity in 12 months

    807103
      So I want to pull up a report of all companies with no logged activities in the last 12 months.

      I am using the following code to give me a list of days since last logged activity: TIMESTAMPDIFF(SQL_TSI_DAY, MAX("- Created Date".Date), CURRENT_DATE)

      I am then filtering by asking for for results greater than 364 days.

      This is great, but if a company has an activity last week, 2 months ago, and 3 years ago, it still shows on the report with the activity 3 years ago. What is the proper way to do this logic?
        • 1. Re: Show all companies with no activity in 12 months
          dpl007
          Hi,
          please try following filter for "Created Date".Date: "is between TIMESTAMPADD(SQL_TSI_DAY, -365, NOW()) and NOW()". Use SQL Expression for both functions insted of Value.
          In order to find out the number of Activity records you can use Activity Metrics. There is field "# of Activity", you can filter on this field with "is not equal 0".
          Regards