Filter using relative date values ("TODAY" etc.)

Hi there, we really need to run filters on dates using relative terms like “today”, “yesterday” etc. -- Salesforce has this ability and it’s extrememly useful: https://help.salesforce.com/articleView?id=custom_dates.htm

Currently, if we want to run a List around our customers who expire at some point in the future, we have to go in and change the “after date” fitler each time to update the current date. (The rolling dates filter doesn’t work in this case, because the dates we’re looking for are in the future and not the past.)

Hopefully this is easy to do, thanks!

THERE NEEDS TO BE A WAY TO USE ROLLING DATES IN THE CRM.

use rolling dates for the Last Contacted date on the CRM/Sales side. This would allow me to contact a customer that I have not had contact with in the last 90 days.

I also think that this would be a brilliant addition. So does one of your hubspot forum moderators!

https://community.hubspot.com/t5/CRM/Filtering-by-before-x-months/m-p/13696#M903

Just switched to HS Sales and I can’t understand why this isn’t a thing there yet, while in Marketing it is.

When adding ‘rolling date’ as an option, please include ‘more than/less than’ at the same time - and make them work together! Like Jean is saying; the function is already part of Marketing, please add it to CRM/Sales as well.

Query: List deals where ‘Last Activity Date’ is more than 30 days ago.

Sales man: Thank you, HubSpot! I’ll get right to it!

And we will all be happy!

yes please - extend the ‘rolling date’ feature to HubSpot Sales as well!

I agree! This would be very useful.

Specifically - I’ve been trying to build ways for our sales guys to filter their contacts based on date last contacted (I can sort based on that - but with 300+ assigned leads, being able to filter would be more useful). I’ve managed a rather painful work around - which is to build the list on the marketing side - and then make the filter on the sales side based on whether they are on the list. But it would be so much easier to have it on the sales side.

Yes, it is very frustrating and limiting the usefulness of the CRM Platform, especially when you combine this with the inability to set deal properties via workflows (other than a very select few, it seems). If I have a custom deal property (for example
“follow-up reminder date”), and I want the workflow to set that property to (for example) 10 days before an existing date property (for example “close date”) I cannot do this easily. You can imagine all sorts of powerful sales workflows that could be built if this functionality was available (send an internal email notification to Hubspot owner and assign a follow-up task 10 days before deal “Close Date”, for example). I could do this easily in Zoho CRM.

What the heck? Why is this not an option? I need to be able to automate a reminder that lets me know when a close date is drawing near. This is stupid simple… not sure why it’s not a thing yet.

Any updates Hubspot team??

I’m surprised by the lack of this seemingly basic, fundamental feature. We could really use it to create filter views e.g. to see accounts that haven’t been checked up on in more than 3 months.

Yes, please. I need this too. Both on contact and company property.

This simple feature alone will get my sales operations to another level!

“Last Contacted” is “Last 90 Days” is possible, but I need “Last Contacted” is NOT “Last 90 Days”…

Yes, we need this!
Surprised that there isn’t a “IS NOT” “Last 7 days”.

Agreed, please add rolling date ranges for all date filters - contacts, companies, deals, engagements, etc.

Have you tried using Lists? HubSpot support helped me create an Active List with “The contact property Last contacted is more than 30 days ago.”

Agreed. The obvious use case being able to filter Deals with a close date in the past

(i.e close date before “Today” with the value of Today changing dynamically not needing a manual change)

Similarly, it would be hugely useful to use relative dates (“today”, etc) to enroll contacts and companies in lists, workflows, etc. We are using Hubspot to facilitate our Product Qualified Lead (PQL) process, so this functionality will make everything much simpler.

Same here we really need to have rolling date feature on Marketing side of Hubspot to create list. Sales side has it and it is really useful

I’d like Smart Lists to contain folks with “Create Date” of, day, “Last Week”…so I don’t have to keep manually changing the hard coded dates every week.

(and no, rolling week, “Last Seven Days” does not help me here. I want “Last week” like Filters give, please)

That’d make Smart Lists *really* Smart :slightly_smiling_face:

This would also improve integration with Databox.

Cheers,

Simon