This can be accomplished with using two date filters and a combination of days ago and days from now but it would actually be useful that you wont need to work this out and figure out the combination - would be nice if you could select date is yesterday
Very odd that you cannot create a rolling forecast. I had an exchange with support and they don’t quite understand that sales forecasts happen in the future. They keep explaining that I should look at the Past 90 days for a sales forecast. That just doesn’t make any sense at all. Is anyone looking at a forecast based on Deal close dates in the past?
This would be REALLY helpful. Google, Bing, Facebook, LinkedIN, and more offer this feature. It would be helpful for HubSpot workflows to be able to do so. Example: I have a field called Demo Date. I need to know if it is scheduled (meaning the date is in the past) or it has been completed (meaning the date is today or later).
This is indispensable.
For example, I’d like to make a different offer to “a company that has received an order within 3 months”.
Unfortunately, this is not possible now.
Nearly three years after original idea posted and still not a feature. This is silly. Very needed feature.
189 upvotes on this one over 3 years - when is this going to happen HubSpot?
You can’t call yourself a CRM and not have basic reporting functions that are applicable *accross the board* on all your objects. It’s crazy that for some objects you can filter by rolling dates and others you cannot.
Is there a timeline for when this will happen?
Hi hubspot Team,
it totally agree to all the others. This a one of the basic feature we need for a standard reporting.
We have the impression, that we have to do the fully reporting within e.g. google data studio.
Hope to see this feature very soon.
Best
Torben
It’s stuff like this that makes hubspot a MAP trying to be a CRM as well. Reporting functionality is heavily lacking; rolling dates is a pivotal field for both automation and reporting.
Yes please! We have plenty of use-cases that require relative date filtering. A simple example would be that we need monthly birthday lists in order to throw some nice words to our contacts…
We definitely need the capabilities for Saved filters to be able to filter with :
date_attribute
* Is before X days after today
* Is after X days after toda
X could be negative or we could have more options like :
* Is before X days before today
* Is after X days before today
This would help me build automations and reports that trigger and update as events or other relevant dates pass.
My immediate need is to separate upcoming appointments from past appointments, and to trigger workflows and reminders for past appointments.
This is one of those “gotchas” for me, coming from Salesforce. Overall, I love HS, but this one hurts.
Yes please
Hello Hubspot !
If we could have rolling date for our filter, our weekly sales meeting will be reported directly in our pipelines in Hubspot, instead of duplicating data in XLSX or DOCX.
That willl encourage sales people involved in cleaning and have their deals up to date.
Thanks
Please can we have an update HubSpot?
It’s been in the same stage for 3 years and attracted a lot of attention.
This is a painful limitation when reporting.
Thanks
I can’t believe this hasn’t been made a serious priority. Not only is there no inbuilt relative date functionality, the operators are limited in so much as in Lists, it only allows “>” than and not “>=”. And I don’t even think the available operators are consistent across Lists, Workflows etc
Such a critical functinoality. 207 upvotes. 3 years. What’s going on? Please provide an update.
As a new customer this lack sure was unexpected. Made working with lists and workflows much harder and introduces more manual work.
This is crazy. The CRM we used 10 years ago let us filter by dates > today, etc.
P.S. Happy 3rd birthday to this idea
Looking for updates on this request too. This is a basic feature of many similar programs.