INTEGRATIONS NEEDED FOR DATE CALCULATOR

ActiveCampaign

You are currently viewing this content for ActiveCampaign.

In this section, you will find the options for building your Date Calculator tool. Follow along in your PlusThis app, or by viewing the numbered step in the screenshots.

Step 1: Start with this date:

In the drop-down, select one of the following options.

A: The current date, when used - this will utilize the day the tool is run as the start date

B: The date found in a field - This will prompt you to select a field and we will use the date found in that field as the start date.
​
If you do not have a field created already, you will need to go into your ActiveCampaign account to create the field, and then come back to PlusThis and create this tool.

C: The date the contact was created - This option will use the date the contact was created as the start date.

Step 2: Treat the start date as:

Select what timezone you would like the start date to be treated as.

Select the "Add a Calculation" button to add a calculation to perform on the start date.

Step 3: Choose type of calculation:

In this drop-down, select the type of calculation you would like to perform on the start date.

A: Add/subtract a static number of months/days/hours/minutes - This calculation type will have you select if you'd like to add or subtract (using the toggle) and then the number of months/days/hours/minutes that you would like to add/subtract.

B: Add/subtract a dynamic number of months/days/hours/minutes - This calculation type will have you select if you'd like to add or subtract (using the toggle) and then select the fields where the number of months/days/hours/minutes that you would like to add/subtract is stored.

C: Find the Nth day - eg. Find the 3rd Sunday that occurs after the above date
This calculation type will have you specify how many (ie. 3), the day of the week (ie. Sunday) and if you'd like to find that instance of the day of the week before or after the above date.

D: Find the Nth date - eg. Find the 3rd occurrence of the 20th, after the above date
This calculation type will have you specify how many (ie. 3), the day of the month (ie. First of the Month) and if you'd like to find that instance of the day of the month before or after the above date.

E: Find the Nth day of a month - eg. Find the 3rd Sunday in the following month
This calculation type will have you specify how many (ie. 3), the day of the week (ie. Sunday) and if you'd like to find that instance of the day of the week of the following or previous month.

F: Find the Nth occurrence of a day in a month - eg. Find the first Sunday of a month that occurs after the above date
This calculation type will have you specify how many (ie. 3), the day of the week (ie. Sunday) of a month and if you'd like to find that instance of the day before or after the above date.

Step 4: Put the calculated date in field:

In the drop-down, select the field where you would like the calculated date stored.

Step 5: Put the human-formatted date in this field:

If you would like to store a "humanized" version of the date, you can select a field in the drop-down to store it in.

Step 6: Format the date like this:

If you chose to store a "humanized" version of the date in a field, you can select the way you would like that formatted in this drop-down.

Step 7: Put the human-formatted time in this field:

If you would like to store a "humanized" version of the time, you can select a field in the drop-down to store it in.

Step 8: Store the result in this timezone

If you would like to store the calculated result in a different timezone than you selected as the timezone to treat the start date in, select the timezone you'd like to store the date in this dropdown.

Step 9: If there is already a date in the calculated field, then keep the existing date (don't update)

By default, this is unchecked, however, if you would like to prevent the field from being updated if there is already a value in it - check this box.

This is an optional section that allows you to store a whole number that stores the count between the start and final calculated date.

Step 10: Put the count in this field:

In the drop-down, select a field to store the count in.

Step 11: Calculate the difference in:

Choose what increment you would like to store the difference in. (Months, Days, Business Days, Hours or Minutes)

Step 12: Allow a negative number result (will be negative if the calculated date is before the start date)

By default this box is unchecked. If you would like to allow a negative number result, check this box.

Step 13: If there is already a count in this field, then keep the existing count (don't update)

By default, this is unchecked, however, if you would like to prevent the field from being updated if there is already a value in it - check this box.

Step 14: Tool Name

Enter a name for your tool in this field. The name is solely for use inside of PlusThis, and will not be visible to customers.

Run your tool virtually anywhere in your automation using a Webhook element.

Step 1: Copy the Webhook URL from PlusThis.

Step 2: Open the automation that you’d like to add the webhook to. The webhook can be placed virtually anywhere in your automation.

Step 3: Click the Plus where you would like to add the webhook. Choose ‘Conditions and Workflow’ from the left hand menu. From there, choose Webhook from the list.

Step 4: Paste the PlusThis Webhook in the pop up and click save.