Skip to main content
Topics#Reports & DashboardsTaylor Hardy's Question
Taylor Hardy asked in #Reports & Dashboards
Apr 23, 2019, 6:19 PM

Relative Date Range That Includes Current Day/Month/Year/Etc.

I'm trying to create a report that shows cases created by month over the last 12 months. The problem is that all of the relative date fields I have found seem to not include the current month. I've also got reports built showing cases created by week for the last n weeks, but it stops on the week before the current week. 

 

Based on what I've seen in this article about relative date ranges it seems as though all relative date ranges for the last n periods of time stop at the time period prior to your current time. 

 

https://help.salesforce.com/articleView?id=filter_dates_relative.htm&type=5

 

Does anyone know if there is a way to show, for example, last 12 months and have it include the current month's data?
4 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Apr 23, 2019, 6:38 PM
    Are you just trying to do something like this?

     

    Filtered By:1 OR 2 

     

       1. Close Date equals LAST 11 MONTHS 

     

       2. Close Date equals THIS MONTH 

     

    Are you just trying to do something like this? Filtered By:1 OR 2 1. Close Date equals LAST 11 MONTHS 2.
Write an answer...
0/9000