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

Frank

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
Status updated 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

137 Replies
JPullan
Contributor

Was this idea ever delivered? Can't see an update since this time last year

PhilZ87
Participant

Yeah you would expect if it's such a requested idea that they give constant updates on this like they give for ideas with around 10 upvotes... But no, no update. Nothing... Really disappointing 

JPullan
Contributor

@bkeller , was this update ever progressed? Seems to have been in planning for a long time.

spencekeith
Participant

Dear HubSpot,

 

Please make this.

 

Sincerely,

 

A customer who has to spend 30 minutes updating date filters for multiple weekly reports I'm required to send every week, every week.

ATse
Member

Have a Today date to use when making calculations or for use in workflows is much needed!

fytt
Member

Really? It's been four years, and nothing on this feature? **bleep**?

SdPounders
Participant

Is there any update to this functionality? 

RHB
Member

here's another plea for an update on this feature please

Walls
Member

I agree! We work with several of our own date properties, not just Close and Create. ALLL of them would be way more useful if I could filter with a simple "before today" or "after today". Seems crazy to me this isn't an option. And to go one step further, it would be amazing to filter as compared to another date field, for instance..."before xxxproperty". PLEASE Hubspot, please!!!!

KZachrich
Member

We would definitiley use this filter! Please HubSpot - make it happen! 

MSundstrom
Member

We really need this feature.  We would use it frequently.

JElliott4
Member

Keep the gas on this one.  It's needed!!

APorter1
Member

Let's knock this out! Practical update that will save us tons of time. 

HBrii
Participant

Is there any update to this functionality? 

Shakermaker
Participant

We need this as well.

MissTipsi
Top Contributor

Last Hubspot update almost 18 months ago. We've had a new Custom Reporting tool in the meantime but this still isn't here. Incredibly frustrating.

GKell
Participant

How's that rewiring going?