Create time since or time until calculation properties (BETA)

To track the amount of time since or until a date, you can create a time since or time until calculation property. For example, you can create a Time since open property to track how long a deal has been open, or a Time until close property to track how far from today a customer is set to close.

A time since or time until calculation property's value is calculated based on the value of a date picker or date and time picker property. To create a property whose values display relative time based on today's date, learn how to create a relative time date/date and time picker property.

Learn more about using today's date and relative time in HubSpot.

Create a time since or time until calculation property

To create a time since or time until calculation property:

• In your HubSpot account, click the settings settings icon in the top navigation bar.
• In the left sidebar menu, navigate to Properties.
• Click Create property.
• Set the property's basic information, then click the Field type tab.
• Select Calculation as the field type.
• For the Calculated property type, select Time since or Time until.
  • For Time since, select the date/date and time picker property whose value will be the start date. The end date will always be today's date.
  • For Time until, select the date/date and time picker property whose value will be the end date. The start date will always be today's date.

• Click Create. Once saved, you cannot edit whether it's Time since or Time until, but you can select a different start or end date property.

Learn more about creating calculation properties.

View and filter by time since and time until property values

You can view the property's value on a record if the selected start or end date property has a value. For example, at this time, the following deal is set to close in 45 days.

You can also filter records by the properties on object index pages or in lists, workflows, and reports. Time since and time until properties can be used with the following operators:

• is less than
• is greater than
• is known
• is unknown

For example:

• View deals for which Time since open is more than 10 days, but there hasn't been any recent activity.

• Create a list of contacts for which Time until renewal is less than 30 days, so you can send them a renewal reminder email.