Add functionality in Query and Lists to allow for rolling date ranges

I'm trying to run a dynamic Query/List that will look at results from the a specific range of time that the time range rolls from day-to-day to continue to only look at that time frame. For example, I want results to show from the last 1 year/365 days, and when I run the query a week later I want it to show results from the previous 365 days from the new date that I'm running it without having to adjust criteria. Currently, I would have to manually enter "between" dates that cover the previous 365 days based on the date I'm running it.

  • Curtis Cecil
  • Oct 14 2025
  • Reviewed: Voting Open
Query
  • Attach files
  • Catherine Burns commented
    27 Aug 23:42

    I completely agree. We spend a lot of time editing date ranges in queries before extracting data for campaigns etc.

    I used Salesfoce in 2012 and could use relative date criteria last n days/ weeks/ months/ years in a reports and enter the parameter n. See the range of options here https://help.salesforce.com/s/articleView?id=analytics.filter_dates_relative.htm&type=5

    Power BI has the same sort of options.

    This would be a game changer for queries and dramatically reduce the need to manually edit dates when reusing queries.

    Currently we sometimes reduce edits by using Greater than or equal to Last month/quarteryear but it means the time period grows and shrinks depending on the current date which is not satisfactory for most queries.

    Attachments Open full size

Related ideas