Date and time calculations
Now you can quickly perform date and time calculations such as adding or subtracting datetime units from a given date. You can calculate a single date or a batch of dates.
Quick action for a single date
- In your workflow editor, click + Add step.
- Select Integrations → Quick action.
- Click Configure.
- In the Quick action operation field, select Calculate datetime.
-
Configure your base date. You can:
- Select Use Now or Today — useful if you want to calculate a day relative to the current time (e.g. in 3 days).
- Manually enter a date in
YYYY-MM-DDformat or select a data reference — useful when calculating a date based on input from another integration step.
- Select the Calculation type - adding or substracting values.
-
Select the Time unit. For example:
Unit Description Example Use Case ”Full Date” Strips time portion; keeps only date. 2025-08-18”Full Time” Strips date portion; keeps only time. 14:32:00”Full Datetime” Retains both date and time. 2025-08-18T14:32:00Z”Minute” Adds/subtracts minutes. ”Second” Adds/subtracts seconds. ”Quarter” Adds/subtracts quarters (3-month periods). - Enter or select the time to adjust.
- Select the timezone to which the calculation should apply.
- (Optional) Configure the advanced settings to exclude or include specific dates. Exclusions only work with adding as the Calculation type.
Supported use cases
Get NOW minus 15 Minutes in ISO format
Get NOW minus 15 Minutes in ISO format
Base date: NOW (selected via Use Now)Operation: Subtract
Value: 15
Unit: Minute
Output Format: ISO 8601
Value: 15
Unit: Minute
Output Format: ISO 8601
Check if a date is within the last 7 days
Check if a date is within the last 7 days
Base date: TODAY (selected via Use Today)Operation: Subtract
Value: 7
Unit: DayUse the output in the Comparison quick action.Formula:
Value: 7
Unit: DayUse the output in the Comparison quick action.Formula:
{Outcome} <= {User-provided date}Add a quarter to a date and compare with another date
Add a quarter to a date and compare with another date
Base date:
Value: 1
Unit: QuarterUse the output in the Comparison quick action.Formula:
{User-provided date}Operation: AddValue: 1
Unit: QuarterUse the output in the Comparison quick action.Formula:
{User-provided date} <= {Outcome}Custom integration for adjusting a batch of dates
- In your workflow, create a form step with two form fields:
- Date — the date you want to use for the calculation.
- Short text — the number of days to add or subtract (as input from the user).
To subtract days, enter a negative number (e.g.
-5). To add days, use a positive number (e.g. 3).- Add an Integration step after the form step.
- Click Settings and configure the integration:
- Method:
POST - URL:
https://integrations.nextmatter.com/g/utils/calculatedate - Headers:
Content-Type: application/json - Body: see examples below
Batch of single dates example
Batch of single dates example
- date — data reference to the date field.
- days_to_add — number of days to shift (negative for subtraction).
- enable_business_days — optional; skips weekends when set to true. Only works for positive values of days_to_add.
Define output variables
In the Results to be used in later steps section, click Add variable.-
For a single output:
Name Value calculatedDate$.date -
For multiple entries (batch):
Name Value calculatedDate1$[0].datecalculatedDate2$[1].datecalculatedDate3$[2].date