HOW TO: Using Zapier to calculate future date properties

[jenniferlim]

A HubSpot workflow is a powerful tool, but one thing that currently isn't possible is the ability to calculate a future date. Within the actions tool, we’re able to set a date property to a static date or the date of action. This isn’t useful if we need to set a date in the future. In this post, I’ll walk you through how we can use Zapier to help us achieve this. *Do note that this will require a paid version of Zapier. 

This is the main overview of the Zap that I’ve set up:

My Zap trigger is a Deal Property Change in HubSpot, specifically a datepicker property called “Sign Up Date”. 

The second step is the key thing here - you need to select a Date/Time Formatter step, and select the option to Add/Subtract Time in the Transform field. Select your trigger date property as the input, and provide the amount of time to add to that field (I’ve selected 14 days in my example). The To and From format is X, which will ensure that the datetime is formatted correctly for HubSpot’s datepicker properties. 

The last action is to update the deal with the future date that’s been calculated. Select the calculated date as the option for your future date (“Reminder Date”, in my example). 

And that’s it! These steps can also be done for any contact or company property updates.

Hope this helps!

Jennifer

[Franci]

Hello 🙋🏼‍

If you have ever struggled with calculating future or past dates, say hello to the Workflow Date Calculator app we have released!

Key Features:

- Set Missing Days: Choose your start date, select your target property, and enter the desired number of days/weeks/months.

- Compatibility: Works seamlessly with HubSpot's standard objects—contacts, companies, tickets, and deals.

Install the App: Head to the HubSpot Marketplace, install the Workflow Date Calculator, and get started for free.

Say goodbye to manual date calculations and hello to efficiency. 

Try the Workflow Date Calculator today and elevate your HubSpot workflow game!

[JAllen2]

Instead of  a hard-coded 14 days, I wish to add a number of days stored in another Hubspot property (of Scoring type). What would be the syntax of that (versus "+ 14 days"). I have tired "+propertyname days" with no luck

[mbinmasoud]

Thank you for sharing this, Jennifer! 

One question: I'm trying to recreate this for a contact date property. I set the "Do this" step to "Update Contact in HubSpot." Under the "Customize Contact" drop-down, the "Object ID" is a required field.  I'm assuming I have select "Hs Object ID" from the available options, correct? 

[cbreiholz]

Hi @mbinmasoud,

Yes, it is the HS Object ID. It is sometimes easier to work with the technical names in Zapier.

If you open the field properties for the contact id in the properties settings, you can also see the technical name (internal name): 

[JenBerenguer]

Thanks for sharing @jenniferlim 🙂