topic Re: Having a dynamic 'today' field in the 'Time between' feature in CRM

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

Achagnon1 — Fri, 07 Aug 2020 16:31:31 GMT

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).

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

gcohen — Tue, 22 Sep 2020 20:15:46 GMT

Yes pleaes. I would love this too.

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

bi_developer — Fri, 09 Oct 2020 09:54:43 GMT

I'm shocked this feature is not supported by Hubspot. This feature is so highly demanded, that it is baked into every coding language in the world. SQL-ers can't live without it. Data scientists and Business Intelligence developers can't live without it. Time Series data (pretty much all Hubspot charts) need it.

Because Hubspot does not support this, I need to build reports to export data into other systems, and now our C-level team are using less Hubspot and relying on other systems. Hubspot needs to support this immediately.

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

Ben7 — Wed, 14 Oct 2020 09:01:32 GMT

Please can this be given priority? It seems elementary and I am also surprised it is not a standard feature.

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

bi_developer — Wed, 14 Oct 2020 09:18:38 GMT

I have written directly to David Hunt, VP, Global Customer Support, to take a look at this community request. I wrote him on October 14, 2020.

Seems like low-hanging fruit that a Dev team could implement in less than one sprint, so all users can make "Time Between" calculations between any datetime property and "Today's Date". We ought to be able to select the output as milliseconds, seconds, minutes, hours, days, weeks, or months. But I would settle for just milliseconds and then I'll build another calculated column to convert milliseconds into days, or whatever is needed.

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

Tlevesque — Tue, 17 Nov 2020 18:23:37 GMT

That's really missing, not having "Today" remove 90% of the usage I can have from this Time between feature...

And a simple increment/update of a day every 24 hours will be enough for me

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

BigeMe — Tue, 17 Nov 2020 20:45:35 GMT

Yes please

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

amtnezschez — Sun, 22 Nov 2020 18:17:56 GMT

Absolutely agree... This is a must have, and development is so simple...

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

bi_developer — Mon, 23 Nov 2020 07:46:59 GMT

Our company is using hubspot less and less because this feature is missing. We painfully export the data from hubspot into another system, just so we can use a getdate() feature in SQL and then use datediff() functions to make our calculated reports. We have talked about creating our own internal system to record and monitor Deals, which would make Hubspot obselete for us 😄

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

erica11 — Wed, 25 Nov 2020 23:15:25 GMT

This is needed ASAP

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

sossp — Mon, 30 Nov 2020 12:41:30 GMT

Please.. implement dynamic today-- and also as mentioned by bi_developer:

"We ought to be able to select the output as milliseconds, seconds, minutes, hours, days, weeks, or months."

Time in between currently switching automatically between hours, days, months and years is really not functional, not reliable and not acceptable. I need to be able to choose the output metric

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

cheryllu — Fri, 04 Dec 2020 19:31:06 GMT

I found this:
https://community.hubspot.com/t5/CRM/How-to-create-a-Today-s-date-date-property/td-p/389836

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

bi_developer — Mon, 07 Dec 2020 04:54:11 GMT

Thanks Cheryllu, I replied to that thread on the workaround solution. Because the workaround workflow is constantly calculating on hundreds of thousands of Contacts (or millions of Deals), like a perpetual for loop, the workflow ultimately breaks down and begins to give incorrect data, and is not a good solution for us. But it might work for smaller Hubspot accounts with a small number of contacts and deals.

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

AdamCrookes — Fri, 15 Jan 2021 03:58:15 GMT

Yeah, I think this is sorely needed.

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

Insight_Studio — Fri, 12 Feb 2021 15:24:21 GMT

This would be very beneficial to have - currently trying to calculate a 'Remaining Time in Contract' date - not possible without creating a workflow to stamp all companies with today's date... every day. Pretty inefficient, pretty painful. Would love to see this implemented.

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

tommitchell — Fri, 12 Feb 2021 15:50:21 GMT

This is badly needed - please implement!

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

bloosbrock — Mon, 15 Feb 2021 17:54:26 GMT

Has anyone received a response from HubSpot acknowledging the need for this and when it might be addressed? Thanks

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

MissTipsi — Fri, 19 Feb 2021 12:23:11 GMT

This is a must, been waiting on it for so long...

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

woody — Fri, 26 Feb 2021 11:04:32 GMT

We have waited too long for this extremely basic feature.

Five years ago, I saw the "dynamic today property" feature on Infusionsoft - a much cheaper automation marketing software than Hubspot. I've also worked with many other software (most of them are basic and less professional than Hubspot) but they all developed the "dynamic today property" feature very early.

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

pauldudley — Tue, 09 Mar 2021 16:57:11 GMT

yes please, very accustomed to seeing this in salesforce