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
81 Replies
slucas
Regular Contributor

I'm truly surprised there aren't more upvotes and comments on this suggestion. 

SO much of the automation is dependent on being able to do rolling ranges as we're able to do in the Sales Contacts view - both per the example above:

  • "this / last  - week/month/quarter/year" etc.

But also - 

  • "is between"
  • and "is more than"
  • and "is less than"

...are critically needed, both in list building and in worflows!!

 

and to make it more confusing, there seem to be some properties where, at least for workflows, it DOES allow relative date date selection, yet other date properties that don't.

 

When trying to re-engage for a contact who's been inactive for a few months, or tons of other use cases that I won't dig in to here, having to manually re-set dates vs the ability to do a relative date is a major limitation to really utilizing the potential power of HubSpot. 

slucas
Regular Contributor

Same comment I made on another related post:

 

I'm truly surprised there aren't more upvotes and comments on this suggestion. 

SO much of the automation is dependent on being able to do rolling ranges as we're able to do in the Sales Contacts view - both per the example above:

  • "this / last  - week/month/quarter/year" etc.

But also - 

  • "is between"
  • and "is more than"
  • and "is less than"

...are critically needed, both in list building and in worflows!!

(to @gerard-_-pf, the option you reference above unfortunately isn't broadly available in all date-driven property filters)

 

and to make it more confusing, there seem to be some properties where, at least for workflows, it DOES allow relative date date selection, yet other date properties that don't.

 

When trying to re-engage for a contact who's been inactive for a few months, or tons of other use cases that I won't dig in to here, having to manually re-set dates vs the ability to do a relative date is a major limitation to really utilizing the potential power of HubSpot. 

Harrya
Occasional Contributor

I wonder - Does anyone know if this issue of not having relative dates applies to paid reports subscription as well? I was considering paying for that but if I still have the no relative dates issue, that would be a non starter for me.

slucas
Regular Contributor

@Harrya

We have the reporting add on.  Relative date filtering is on some properties, not all.  Haven't figured out yet what differentiates.  Frustrating. 

That said - reporting add on is significant added functionality, and still worth it. 

BJSzyjakowski Regular Contributor | Gold Partner
Regular Contributor | Gold Partner

 I agree with both parites who already commented. These rolling dates are a must for all events and properties that have any kind of date refinement. 

Danielbrinch
New Contributor

Yes, we need this!

Surprised that there isn't a "IS NOT" "Last 7 days".

thisisdatis
Regular Contributor

Another massive inconsistency issue with HubSpot. First, I discover that their multinational SEO tool is available on their COS and Landing Pages ... but not their blogs (if you need it on one, you'll need it on the other). Now the inconsistencies with rolling dates. Why not have the same functionality for all the different modules??? I can't set up follow-ups based off the day someone has an event... I can't send feedback follow-ups... I can't even send opp follow-ups. 

 

Really really big miss here and absolutely shocking that this doesn't have thousands of votes.

TheoB
Occasional Contributor

Hubspot is currently very inconsistent with the options for filtering properties by date range - whether in workflows, lists, dashboards, etc.

 

Many properties allow you to filter by a rolling date range - e.g. "more than 7 days" or "less than 1 day" from the current date.

 

However, many others only allow you to filter by specific dates - e.g. "after the 27th of October 2018".

 

For example - you can have a rolling range for "last contacted" for contacts, but not for "last contacted" for deals!

 

Similarly - no rolling date ranges for "activity date".

 

This drastically reduces the power of hubspot automations - at least two attempts to set up automations for our company in the last week have come to nothing because a given property cannot work with a rolling date range.

 

(We wanted a smart list of all the contacts who have been called in the last 24 hours - not possible; we also wanted a workflow that set reminders to contact deals that have not been contacted in the last week.)

 

 

Screen Shot 2018-08-02 at 09.21.50.pngDeals - no rolling date rangesScreen Shot 2018-08-02 at 09.21.34.pngContacts - rolling date ranges

 

TheoB
Occasional Contributor

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

javirevi
Regular Contributor

Yesterday, Today and rolling dates should be available filters everywhere where dates are involved.

 

Is there a specific reason why these are not available in some places and tehy are in others?

 

As an example, it would be very useful for us to be able to filter if somebody has more than one deal in the same day (or a rolling time).

 

Regards,