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!

HubSpot updates
changed to: In Planning
Apr 16, 2020

Hey HubSpot community - 

We know date filters can be a pain point for many of our users. We are currently reworking some of the "wiring" on our filters system which will set us up to be able to add consistency to our filters. Part of that will be introducing relative date filters where they are not currently available. 

 

Thanks

Jan 9, 2019

Agreed! Additionally, when using a contact date picker property, it's possible to use the "more than/less than X days/weeks ago" filters as list criteria. However, this isn't possible right now for company date picker properties. This is a key feature for list segmentation! Thank you!

111 Replies
New Contributor

I'm with the others on this... today, current week, current month/year, last x weeks/months/years etc. would all get used by me. 

Regular Contributor

Please please please add this across lists, workflows, etc.

New Contributor

I would be happy to just get "Yesterday" into each scroll down where the option of "Today" currently exists.

HubSpot Product Team
HubSpot Product Team
updated to: In Planning

Hey HubSpot community - 

We know date filters can be a pain point for many of our users. We are currently reworking some of the "wiring" on our filters system which will set us up to be able to add consistency to our filters. Part of that will be introducing relative date filters where they are not currently available. 

 

Thanks

Regular Contributor

Whoop whoop! Thank you @bkeller !!

Regular Contributor

YESSS! Thank you.

Regular Contributor

I need filters that I can use to say this activity has not happened in X time frame. 

 

An example: 

Show me customers that last logged in more than 2 weeks ago. 

Occasional Contributor

I need this relative date feature as well.  I'm working on creating a report of tickets opened today for a particular client, and have it scheduled to run daily.  Having to go in and change the date manually each day negates the ability to schedule a report to run on its own!!

Regular Contributor

@bkeller thanks for the update. Is there an expected delivery date for this feature? In the coming months?

Regular Contributor

Yes, please add this.  I'd like to use something like show me deals that haven't had sales activity for more than 90 days.  I can currently do this withIN the 90 days using the Activity Date  IS  "Last 90 days" options, but I can't do it to show what's NOT in those 90 days for example.   I could perhaps create a list using that as an exclusionary factor, but it's a pain.  

 

This could also be helpful for companies like mine that have a non-calendar year fiscal year mismatch.  On some reports, we have to edit them quarterly...

Regular Contributor

Dear HubSpot Product Team,

You wrote: "In planning" a couple of months ago, so any idea about when this very popular enhancement request will be released?

Thanks

-Gabriel