How can I calculate a date field based off another date field?

[JRoyle]

So I know there is no easy way to do a date calculation in Hubspot that I can find. 

But I want to take the close date and add 60 days to it to put as an expected launch date.  Any idea how I can do this simply?

[karstenkoehler · Accepted solution]

Hi @JRoyle,

Out of the box, this is unfortunately not possible. Per default, you would have to enroll a contact in a workflow, set a delay for the desired time and then stamp the date after that delay. Up until the point when the date property is stamped, the information would not be available.

There are two workarounds for this that I know of. The first would be using a third-party solution like Zapier or Automate.io. @Arlene wrote a nice step-by-step instruction on how to add time to a date property using Zapier here.

Alternatively, this is something that can be achieved with custom code and programmable automation in HubSpot's new product, Operations Hub.

Hope this helps!

[karstenkoehler · Accepted solution]

Hi @JRoyle,

Since my first reply, HubSpot expanded on the functionalities of calculation properties: https://knowledge.hubspot.com/properties/create-calculation-properties

This can now be easily achieved with such a property, see this example that calculates a date 30 days after the record create date:

The number of days is the first number in brackets. The rest of the numbers are there to calculate the amount of milliseconds as that's the unit HubSpot uses here.

If you want to calculate a date before, simply switch the + for a - sign.

Best regards!

[AMammarella]

Hi everyone,

since we had the common need to find a solution to this problem, we have published in the HubSpot marketplace "Future Date Calculator" app.
The app adds a new deal-based workflow action that enables you to dynamically include a line item in an already existing deal.

The Future Date Calculator app automatically populates a property with a future date based on another chosen date property.
Furthermore, it calculates the number of days until the specified date, so all you need to do is enter the desired number of days.

Try it and send us a feedback!
We're constantly working on new features for this app, every feedback would be very helpful.

https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/future-date-calculat...

Best,

Alessio

Alessio Mammarella HubSpot Specialist Exelab

333-6580788 alessio.mammarella@exelab.com exelab.com

[Lauren_Elizabet]

This would be really great option to offer with this step outside of creating custom code

[karstenkoehler · Accepted solution]

Hi @JRoyle,

Out of the box, this is unfortunately not possible. Per default, you would have to enroll a contact in a workflow, set a delay for the desired time and then stamp the date after that delay. Up until the point when the date property is stamped, the information would not be available.

There are two workarounds for this that I know of. The first would be using a third-party solution like Zapier or Automate.io. @Arlene wrote a nice step-by-step instruction on how to add time to a date property using Zapier here.

Alternatively, this is something that can be achieved with custom code and programmable automation in HubSpot's new product, Operations Hub.

Hope this helps!