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.  

[iamathlete]

i completely agree and have had to create two properties and a 3-layered workflow to do something that can be simply solved by allowing dates to be compared to Today.

[jpalarcon]

it's a must... for reporting, for calculation properties, etc, etc, etc...

[hzey11]

My company is also in need of this function, any updates on if it's been added to a product roadmap?

[MStefan5]

Yes please, sincerely need this as most reporting hinges on it.

[Bruno_Petersen]

We are adding today's date on some selected records through the API. It's not a great solution and it does not help with a lot of the reporting and automation needs. 

It is incredibly frustrating that HubSpot does not have "Today's Date" since this is something so obvious. 

[gabeharper]

Please add this. Surprised to discover it missing, and is definitely causing friction here.

[Remarkable]

Any updates on this? It's really holding our transition from SFDC up...

[pauldudley]

yes please, very accustomed to seeing this in salesforce

[woody]

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.

[MissTipsi]

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

[bloosbrock]

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

[tommitchell]

This is badly needed - please implement!

[Insight_Studio]

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.

[AdamCrookes]

Yeah, I think this is sorely needed. 

[bi_developer]

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.

[cheryllu]

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

[sossp]

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

[erica11]

This is needed ASAP

[bi_developer]

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 😄 

[amtnezschez]

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

[BigeMe]

Yes please