HubSpot Ideas


Future Rolling Date Range

The sales team needs to be able to view a report that shows upcoming close dates for deal in particular stages. Ideally, it would be a report that would show the NEXT 120 days. 


Currently, the only options for rolling date ranges are for the LAST X days.  


An option for NEXT X days is needed.

77 Replies

This is really needed to understand future business.  Please prioritize this as it should be very easy coding to to NEXT X Days in the same way you do LAST X Days


I would like to hear a response from hubspot about this, as this seems a very simple feature which a lot of customers would have a strong use-case for.


Some options for NEXT x days is deperately needed.  


I need to see what is going to close in the next 14 days - and I can't do it.


We also need a rolling future time period urgently.  Without it is like having to drive a car with front window blacked out. Sure rearview mirrors are useful once in a while, but in order to run a business we need to be able to look ahead. At the moment HubSpot doesn't really help me to that. That's frustrating, especially since this seems like a very basic feature, that's not a big deal to implement.


We would like to have a rolling forecast for the next 1, 2 and 3 months. That would really help us.


Is there a timeframe for getting this implemented?

HubSpot Product Team

Hi folks,


I’m Meaghan Griffith, the product manager for HubSpot’s reporting tool.


Thank you all for taking the time to submit, upvote, and comment on this Idea. We hear you loud and clear, and we agree that this functionality is important. We are currently evaluating if this Idea is feasible and, if so, how our team will implement it. 


Any news about this feature request will be relayed on this thread, so stay tuned.


Thanks again, 



I would also suggest Rolling Future Weeks in addition to days.  For Example:  in the case of deals, Close date in next (x) weeks


thats a great idea!

We need this urgently to make our forecasts!


I am surprised this request has been taking this long, given as originally called out the functionality requested is already there but just for PAST days rather than FUTURE days. All that is needed is take the "Rolling date range" filter already there to include not just LAST but also NEXT days (please see screenshot below). Should be very simple to implement, and it is so crucial for our business reporting (for which we pay a significant monthly fee) to work properly and make sense for our business (as it is for many others given the upvotes/comments).


Glad to see this has been picked up for review a few weeks ago, but would very much value the implementation being accelerated given the apparent ease and simplicity of this request.


Thank you so much!


SCREENSHOT OF EXISTING "LAST" options to be augmented with "NEXT" options :



This is what we need as well - manually setting the future date range every week / month across a lot of reports is very time consuming and seems like such basic functionality for a reporting tool.


also why on the rolling date feature can you not include current day?


i have a report i want to show "hot leads" which include any that have had a status update in the last 30 days


however with the rolling days feature it only shows last 30 days not including today. therefore if something has been updated today it would not appear in the report


Agreed. We need to have the "Rolling date range" available for future dates, not just past dates - This would be extremely helpful as right now you can't automate reports, as you have to change the custom date range, every time and that's not a long-term solution.


Our least senior developer could program this feature from his phone while waiting at a stoplight. There's more energy going into typing requests than it would take to just do it.


I can't imagine there's internal debate on the utility of future data ranges for a forecasting report.


I really hope this is being implemented anytime soon! Need it for optimizing my dashboard and to save a lot of time editing reports. Thanks!


Thank you for the help.


ideally just like to add. next 30, 60, and 90 days to "rolling date range"

More interesting if forecasting forward.


Please let me know if you have any quesitons or ideas.


2021-01-08_9-59-43 hubspot.gif

Contributor | Platinum Partner

Is there a status on this? One of my clients is looking for this exact feature. Quite a bit of time is being wasted each week updating reports with new date selections.


Tweaking their reports, here is an interim solution:

Update the Date Property/Date Range to All Data


**In this example, we are using Close Date**

Under Filters, add that Field and select "Days to Close is between 0 and 180"


Please get this done - it is a very basic feature for any forward looking team


Any updates on this @mgriffith


This is be really heavily needed by a lot of users.

We are currently building around this with external systems quering information through the API, doing primary school calculations and then writing the information to a new field in Hubspot. This is really the most expensive workaround every 🙄 Unfortunately workflows are not able to solve those date challenges as they can also not to calculation. Its the same as having the today date available for calculation that is not possible.


This shoul dbe very basic functionality. If we can go backwards why cant we go forwards?


There is a similar request perhaps go here and vote as well