Quick tipHow toSmart CRM

Calculate the time between two dates

No custom code needed to measure days between two dates.

Subscription
Professional or Enterprise
Permissions
Property settings access
Time
4 min · Intermediate
Last verified

Short answer

HubSpot's KB: calculation properties can measure the time between two date properties, or time since or until one date. The custom equation function time_between(date1, date2) returns a number. Raw Time between values are stored in milliseconds, and dates without a time use 12:00 am UTC.

1. Calculation settings

A calculation property in my demo portal.

Calculation property settings with Custom equation, Output type Number, Formatted number and a formula editor
Type (1), output (2), and the formula editor (3).

2. Units

In a custom equation, divide milliseconds by 86,400,000 for days.

3. Related

Calculation properties.

Sources

New field notes by email

One email when a new article publishes.

Still stuck?

If this did not fix it, the problem is probably specific to your setup. Book a call and we will look at it together.

Book a call with Sam