How do you calculate time between dates for better reporting and segmentation?

Smart CRM & Sales Hub Dashboards & Reporting
1

Hi everyone,

I’ve been working on improving reporting and segmentation inside HubSpot, especially when it comes to tracking time-based data like customer lifecycle, deal duration, and campaign performance.

While HubSpot workflows and properties allow some level of automation, I’ve noticed that calculating the exact difference between two dates for example, lead creation vs. deal close date can sometimes require extra steps or custom solutions.

In my case, I started using a simple external reference approach with a calculadora de datas online to quickly validate date differences and ensure consistency in reports. This helps especially when dealing with edge cases like different month lengths or long-term timelines.

I’m curious to know how others here handle this:

  • Do you rely entirely on HubSpot workflows for date calculations?
  • Do you use custom properties or external tools for validation?
  • Any best practices for improving accuracy in time-based reporting?

Looking forward to your insights!

2

Hi @Calculadora12,

Calculation properties can solve for most of these cases: Create calculation and rollup properties

Additionally, in segment filters, workflow filters, report formula fields and datasets, it’s possible to check if one date is before another or - in combination with calculation properties - if it’s above or below a specified duration. These tools have covered most of what I’ve encountered over the years.

Best regards