Having a dynamic 'today' field in the 'Time between' feature
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).
[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.
[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!
