HOW TO: Using Zapier to calculate future date properties
Apr 27, 2020 6:23 AM
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!