Date calculations

​

Calculate a date with a no-code step

1. In your workflow editor, click + Add step.
2. Select Integrations > Quick action.
3. Click Configure.
4. Click the Quick Action operation field and select Calculate Datetime.
5. In Base datetime, choose Use Now or Today and pick Now or Today, or choose Enter datetime and enter a datetime (YYYY-MM-DD HH:MM:SS) or a data reference from a previous Date form field.
6. In Calculation type, select Add or Subtract.
7. In Time unit, select the unit to add or subtract, such as Day, Week, or Month.
8. In Time to adjust, enter the amount, for example 5, or a data reference. For Date, Datetime, or Time units, enter a value in that format to compare with the base datetime.
9. Select a Timezone. This applies to the base datetime and to datetime values in Time to adjust.
10. Optionally select an Output format. You can also format a date data reference later.
11. Optionally expand Advanced excluding configuration to skip weekends, holidays for a country, or custom days (YYYY-MM-DD,YYYY-MM-DD).
12. To reuse the result in later steps, add Calculated Date in Response data for use in later steps. See Variables in workflows.
13. Save your changes.

​

Calculate a date with a custom integration

1. Open your workflow and create a form step with the two form fields. Click + Add form field and create the following:
   • Date: The date when you want to apply the calculation.
   • Short text: The number of days to add or subtract when running your workflow.
   To subtract days, enter a negative number such as -5. For adding days, type the number.
2. Create an integration step after the form step.
3. Click Settings to configure the step. Enter the following details:

• Method: POST
• URL: https://integrations.nextmatter.com/g/utils/calculatedate
• Headers: Content-Type: application/json
• Body might look like the following:

{  
  "date": "<DATE>",  
  "days_to_add": "<NUMBER OF DAYS>",  
  "enable_business_days": "<TRUE or FALSE>"  
}

{ 
  "date": "2022-07-01", 
  "days_to_add": 1, 
  "enable_business_days": true
}

{
  "date": "{1. Enter Date Info - Choose initial date - Date}",
  "days_to_add": "{1. Enter Date Info - Choose days to add. Use a minus if you want to subtract days. - Input}"
}

[
  { 
    "date": "2022-05-01", 
    "days_to_add": 1, 
    "enable_business_days": true
  },
  { 
    "date": "2022-06-01", 
    "days_to_add": -5, 
    "enable_business_days": false
  },
  { 
    "date": "2022-06-01", 
    "days_to_add": 2
  }
]

• In the Results to be used in later steps, click Add variable. You need to create a variable for every date set so that the resulting date can be referenced in later steps.
  • For one date set, add the calculatedDate variable with the value of $.date
  • For multiple sets, your variables might be the following:

  Name	Value
  calculatedDate1	$[0].date
  calculatedDate2	$[1].date
  calculatedDate3	$[2].date