Having a dynamic 'today' field in the 'Time between' feature

[Achagnon1]

I'm in the process of setting up calculated properties to use the new "time between" feature in reporting, and realized that, in the 'time between' calculations for properties, I'd like to have access to the option 'today,' which would be a dynamic date set as the value of today's date.

That would allow me to track dynamically how long has it been since a deal has been created ('today' minus 'create date' = how far along we are in the sales cycle up till now). 

[SkeeStylus · Accepted solution]

Great news everyone.  Looks like the the excellent work of @rwebb1 and the product team we can now filter, report on, and sort by the time since or the time until an event.  Great addition!  Here's more on the full BETA.  

[NVlahov]

Really Need this. Please invite me if there is early beta, pre-beta, any beta. It would solve so many of my urgent data issues.

[TCornRain]

Very encouraged to see this is getting some eyes by the product team. We really need this functionality to take our pipeline management to the next level within HubSpot. We currently have to export to Excel to run the reports needed to manage our team against rules of engagement. 

[kirstenmhb]

Really looking forward to seeing this feature! We have a couple of specific use cases where we are currently using a workaround that is complex and involves multiple workflows. With such a property, we could simplify and streamline our workflow 🙂 

[shajones]

Hi all!

It's Shay again from the Product Manager on the CRM product team.

Again, thanks to everyone for taking the time to submit, upvote, and comment on this Idea. We’re still reviewing this idea and trying to determine the best way to implement this in HubSpot. Turns out it’s a fairly complex engineering problem. To better understand all of the use cases for this type of field, we've created this survey and would very much appreciate it if you all could take a couple of minutes to fill it out.

Thanks,

Shay

[WJames7]

Six months without an update? We're new to hubspot, just ran into this missing functionality,
Surprised and disappointed this hasn't been addressed with gusto.

This issue will influence our long-term CRM decisions if not addressed;

hubspot it's up to you to protect your revenue stream by taking care of the basics.

[H_yukawa]

I'd like this,too.

I really need it!!

[LSilva8]

Please, this feature would be much appreciated !!

[CaptainSprocket]

Please.

[Ruben_tB]

@shajones really, really, but really looking forward to an update! 

[mvdbree]

@shajones Excellent to hear! Looking forward to an update.

[JoeGlenn]

Wow someone from HubSpot finally responded and acknowledged our request.

Thank you and please keep us advised.

[shajones]

Hi folks,

I’m Shay Jones, the Product Manager on the CRM product team.

Thank you all for taking the time to submit, upvote, and comment on this Idea. We hear you loud and clear, and we agree that this functionality is important. We are currently evaluating if this Idea is feasible and, if so, how our team will implement it. 

Any news about this feature request will be relayed on this thread, so stay tuned!

-Shay

[tmitch_sona]

Almost two years on from adding my voice to requesting this essential functionality at my old company, it still appears to be nowhere near coming to fruitition so I'm posting again from my new company. PLEASE Hubspot - this should be really basic functionality 🙏

[CMcLaird]

We are considering an option with custom code, which appears to be an action available to us in workflows. Using javascript, our intent is to create timestamp fields populated by our first custom javascript code, dumping the date and time to a field. The second will calculate the difference in minutes between two timestamps, excluding non-business hours. If anyone has any feedback on this idea, please share. Or if anyone has done this already, this group would likely benefit from anything you can share.

[TmurphyParspec]

Any update on this? 

[SGross27]

Upvoted!

Thanks for the workaround, too

[MGan]

I've seen this requested by several customers. A today's date property is sorely needed. There is a workaround https://community.hubspot.com/t5/CRM/How-to-create-a-Today-s-date-date-property/td-p/389836 but it's added friction for our customer's exeprience!

[DReyes815]

Echoing this idea - it's sorely needed for reporting and making use of the "Time Between" equation. Doesn't make it possible to create our own Days since _________ kind of properties

[BJansen11]

Please, add this. It can't take too long to implement TODAY feature. It's essential to our analysis.

[LYu]

Please add this.

[DimitriAntoniou]

YES THIS! This would unlock so much value in viewing how long someone has been in their current stage!