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

[CSaß]

+1

[MValleskey]

We have been asking for this for years. So do not hold your breath

[rwebb1]

👋Hi everyone! Sharing two updates: 

1. [Rolling out to all customers] Display relative time from 'today' for Date and Datetime properties (demo😞 Quickly visualize and understand “how long until” or “how long since” a moment in time, using existing date/datetime properties.
2. [In beta] Create 'time since' and 'time until' calculated properties (demo😞 Create two new types of calculated properties, Time Since and Time Until, to calculate the time between a date/datetime and Today. During the early stage of this beta, you will not be able to filter on these properties in places like Lists, Workflows, and CRM Views. This support will be added while the feature is in beta.

This Knowledge Base article covers both the solutions above plus existing functionality in HubSpot to filter and trigger automation based on today's date, some of which was described by Jeff in this thread. Please shoot me an email at @ rwebb@hubspot.com or book time if you have questions or feedback on these solutions! Thanks for the feedback you've provided thus far!

[TKadavil]

+1

[SkeeStylus]

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.  

[garciapiano]

Man... this cannot come soon enough! Not having this feature is like trying to bake a cake without a timer!

[RPepin9]

Love this new beta that allows us to create 'time since' and 'time until' calculated properties. I just was implementing some things and realized these properties can't be used in conditional formatting. Any chance that will be added? 

[rwebb1]

 👋Hi all, quick update on the 'create time since/time until properties' beta. These properties can now be used in filters (lists, CRM index page views), automations (as a filter), and can also be used to build reports. Here is a fresh demo and updated KB article that reflects these changes. You can opt into the beta here. 

Mobile support for these properties is coming shortly, and we are looking into getting these available in conditional formatting in reports. Thank you for your feedback!