Hi Community,
I wanted to share a really good product update that as featured in our product spotlight recently.
The 'Time Between Calculation’ in properties. You may have seen this thread discussing the need in the past.
This contact property calculation can be used to measure the time duration between two important date properties for you.
I want to create a thread for customers to share their use cases as the opportunities are endless to how this could be used.
To start things off, one quick example of this would be to measure the difference between a customer becoming an MQL and becoming a customer. This can be then used to measure deals individually or even pull an average for every existing customer in the database to benchmark against.
Example:
This is an awesome feature @Cianodonoghue! Is it also possible to use this to calculate “time since” - in other words, time between a Hubspot property and today?
Hi,
I thought I would comment in for a customer, as well as check with you on this. Within this article, it is stated that:
In the object record (e.g., a contact record), the displayed value will be in hours, days, months, or years. For example, if the time calculated is one month and twenty days, then the value displayed will be One month
May I know why is this so vague? Can’t we display it more exactly such as “50 days” or something? If it is round off to “One month”, this is really a very limited functionality.
Hi @Drumcircle and welcome, we are so glad to see you here!
Thanks for reaching out to the HubSpot Community!
You should be able to calculate the age in years with a time since calculation.
Here is the article about it: “Create time between, time since, or time until calculation properties”.
Let me know if that helps!
If this is not what you are looking for, please share some more detailed information and we’ll be glad to look at it!
The more info, screenshots (without sensitive/confidential information), and details you can provide, the better the Community can assist.
Have a brilliant day!
Bérangère
One work around on this (that is admittedly silly and inefficient, but does work) is to have a daily workflow that sets a “today” property on the record. I have found that I need yesterday, today, and tomorrow properties on a few objects, and I update them with an off-hours workflow. Again, annoying and inefficient, but this allows me to trigger actions on days even if native triggers do not. It also allows the calculation you’re after. Hope it helps.
