HubSpot Ideas

basil

Support Properties of Type Date in Calculated Field Formulas

For us it seems to be an easy win to support differences between two date properties in calculated fields. We would use that for

 

- Time to warranty decision (days)

- Payment overdue since X days

- Average time to settle invoice of company

- Time to first reply from engineering team

- ...

 

Basically you could calculate the number of days between two date properties. Optionally you could extend this to include time - but that would not be needed vor an MVP.

3 Replies
cedaly
Contributor

It seems odd that this is not in the Calculated Fields already considering that HubSpot has created predefinde time in stage calculations.  Kind of a miss to not allow calculations on date which is critical to sales velocity.

graceotaiza
Participant

In our case, we have a payment due date that is 2 weeks before an event date. We would love it if Hubspot could have that property calculated. 

AmyMcP
Participant

This would solve a lot of our problems. We want to be able to trigger emails to clients based on it being '7days after'/'6 days before' a date. Has anyone found a way around this?