We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).

Allow cookies

Allow the use of relative dates in workflow/smart list criteria

Status: In Planning
CCasemore
Submitted by on ‎Aug 17, 2017 12:09 PM

HubSpot Marketing currently only allows smart lists and workflows to use Deal date fields as absolute values (eg. August 17, 2017). This makes it very difficult to create smart lists and workflows based on aging deals or moving time ranges.

 

The ability to use relative date fields (eg. today, older than 2 weeks, less than 2 months ago) would open up so many possibilities in dynamic workflow enrollment.

See more ideas labeled with:
HubSpot updates
Status updated to: In Planning
Apr 16, 2020

Similar to https://community.hubspot.com/t5/HubSpot-Ideas/Filter-using-relative-date-values-quot-TODAY-quot-etc/idi-p/5453. This is currently in planning. Thanks everyone. 

Status updated to: Delivered
Jan 18, 2019

Thanks all for sharing your feedback. This is now available in deal-based workflows. It's not currently possible with deal triggers in contact-based workflows, but we plan to add it in the future. 

33 Replies
Jams
Occasional Contributor
‎Dec 20, 2018 1:38 AM

I genuinely cannot believe Hubspot doesn't have this. Please address as a priority.

Status updated to: Delivered
bellawu
HubSpot Product Team
HubSpot Product Team
‎Jan 18, 2019 11:38 AM

Thanks all for sharing your feedback. This is now available in deal-based workflows. It's not currently possible with deal triggers in contact-based workflows, but we plan to add it in the future. 

anejako
Occasional Contributor
‎Jan 18, 2019 11:48 AM

Great to hear!

Alex Nejako

Marketing Manager

TCC

annieseattle
Regular Contributor
‎Jan 18, 2019 1:37 PM

it's great to see that there are some relative options based on when the field has been updated, but I think that this issue is more about having something that can do a workflow like this:  

 

If deal is in deal stage = trial and  trial start date (custom field) = today (not a specific hard date, but a floating date so that when that date is reached, the workflow gets kicked off), 

> send welcome to the trial email

> delay 1weeks

> send how's the trial going/need any help?

> delay 1 week

> send 1 week left in the trial, schedule a call to discuss feedback, etc.

> etc. etc.  

 

We'd like to do the same for when a new deal is closed and contacts/users are added to send them a welcome email based on their contract start date (custom deal field).

 

This would be so useful.  Is this coming soon?  Thank you!

kyle2
Occasional Contributor
‎Jan 20, 2019 10:21 PM

Great to hear! Thanks so much, Hubspot. Definitely hugely useful.

JosieSA
Regular Contributor
‎Jan 21, 2019 2:58 AM

hi 

 

@annieseattle you might be able to achive this by using your enrollment criteria "when the trial date  field value = is known" . That way when you populate the field it can trigger the workflow

MichelleFink
Regular Contributor
‎Jan 22, 2019 10:32 AM

@annieseattle   This written example describes what we are trying to do and exactly why I followed this Hubspot idea. The solution for this particular problem is not to start the workflow when a field has been filled in or "is known". @JosieSA  The main problem is that deals that close can start on different dates. People might sign the contract on 12/31/18 but not actually begin services until 1/23/19. You don't want to trigger the workflow on 12/31/19 when you enter in the 1/23/19 date into a custom field. Check in emails would start going out before the work has even begun. There needs to be a way to trigger actions based off of a custom date field.

HansW
Occasional Contributor
‎May 22, 2019 4:03 AM

Please extend this filter feature also to Active Lists.

It makes totally no sense having to update an absolute date in these filters!

AlexWall
New Contributor
‎Jul 4, 2019 4:46 AM
To all people interested in getting this fixed, please Upvote the Master Idea below.
There were 15+ ideas on the forum related to date-filters, each being relatively small and describing one or two issues. That made this unlikely to be prioritized by Hubspot. In an attempt to accelerate this, we've made a complete analysis of what's missing and what Hubspot needs to develop. We created one holistic Master Idea aimed at describing the entire issue and collecting all Upvotes. Please vote on this idea now:
 
Date-filters: Improve Options Across all of Hubspot [Master Idea]
danieldirks
Regular Contributor
‎Feb 1, 2020 1:47 PM

yes please - would be great!!

Status updated to: In Planning
bkeller
HubSpot Product Team
HubSpot Product Team
‎Apr 16, 2020 7:42 AM

Similar to https://community.hubspot.com/t5/HubSpot-Ideas/Filter-using-relative-date-values-quot-TODAY-quot-etc.... This is currently in planning. Thanks everyone. 

tahnee
New Contributor
‎May 14, 2020 8:55 PM

Really important functionatlity - great to see it is in planning. 

azalaquett
Regular Contributor
‎Nov 6, 2020 11:56 AM

Last Deal Modified Date is 60+ days ago....applicatons to Workflows and Reporting are BIG. 

Big limitation - HubSpot - do you hear us?