Calculate Date

Contents

Calculate Date


Add action


Use context menu or action toolbox to add Calculate Date action to workflow scheme.

  • Click on the area with (Edit) 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 (Edit) 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:

  • Calendar time;
  • Working time.
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.