Contents
- Calculate Date
- Add action
- Configure action
- Action properties
- Examples
DocTrix WorkFlow for SharePoint 2019
- Add Item to Collection
- Build Dictionary
- Calculate Date
- Calculate Value
- Clear Collection
- Count Items in Collection
- Find Interval Between Dates
- Format DateTime
- Get Item from Collection
- Get Item from Dictionary
- Join Items in Collection
- Regular Expression
- Remove Duplicates from Collection
- Remove Item from Collection
- Remove Value from Collection
- Replace Value in Collection
- Set Variable
- Set Workflow Status
Calculate Date
Calculate Date
Add action
Use context menu or action toolbox to add Calculate Date action to workflow scheme.
- Click on the area with (
) icon on the scheme and:
- Select category Operations;
- Choose Calculate Date.
- In action toolbox:
- Select category Operations;
- Drag and drop Calculate Date action to the area with () icon on the workflow scheme.
Configure action
Open action configuration dialog to edit action properties:
- Open action context menu on the scheme and choose Edit;
- Or double click the action on the scheme.
Action properties
Use configuration dialog to edit action properties:
| Property | Description |
|---|---|
| Title | Defines action title. By default the title is action type name. |
| Input | Defines input date. Lookups are available for this property. |
| Mode | Mode of adding time intervals:
|
| Months | Number of months to add to input date. Negative values are acceptable. Lookups are available for this property. Available if mode is Calendar time. |
| Days | Number of days to add to input date. Negative values are acceptable. Lookups are available for this property. Available if mode is Calendar time. |
| Hours | Number of hours to add to input date. Negative values are acceptable. Lookups are available for this property. Available if mode is Calendar time. |
| Minutes | Number of minutes to add to input date. Negative values are acceptable. Lookups are available for this property. Available if mode is Calendar time. |
| Working Days | Number of working days to add to input date. Negative values are acceptable. Lookups are available for this property. Available if mode is Working time. |
| Output | |
| Date | Variable to store the result date. Only variable of type DateTime are available for this property. |
| ISO 8601 date string | Variable to store the result date in ISO 8601 format. Only variable of type Text are available for this property. |
Examples
Add 5 calendar days to the current date:
Subtract 3 business days from the current date:
In “Working time” mode the regional settings of the current SharePoint site and data from “ZFlow Calendar” list are used to calculate working time.