Calculate date

Adds or subtracts a time period from a date to create a new date.

Action settings

Field

Description

Date

The base date of the calculate. Options to create a base date.

  • A specific date
  • A lookup from a variable or list
  • The current date.

The time period change will be applied to this date.

 

The number of years to add or subtract to the specified date.

The value can be:

  • Manually entered
  • A lookup from a variable or list

Note: A negative value can be used for a subtraction operation. You just add minus to whatever value you have.

For more information on lookups, see Use lookups and Lookups reference.

Months

The number of month to add or subtract to the specified date.

The value can be:

  • Manually entered
  • A lookup from a variable or list

Note: A negative value can be used for a subtraction operation. You just add minus to whatever value you have.

For more information on lookups, see Use lookups and Lookups reference.

Days

The number of days to add or subtract to the specified date.

The value can be:

  • Manually entered
  • A lookup from a variable or list

Note: A negative value can be used for a subtraction operation. You just add minus to whatever value you have.

For more information on lookups, see Use lookups and Lookups reference.

Hours

The number of hours to add or subtract to the specified date.

The value can be:

  • Manually entered
  • A lookup from a variable or list

Note: A negative value can be used for a subtraction operation. You just add minus to whatever value you have.

For more information on lookups, see Use lookups and Lookups reference.

Minutes

The number of minute to add or subtract to the specified date.

The value can be:

  • Manually entered
  • A lookup from a variable or list

Note: A negative value can be used for a subtraction operation. You just add minus to whatever value you have.

For more information on lookups, see Use lookups and Lookups reference.

Time is

Specify whether the date is being specified according to the server's locale settings time zone or UTC time. 

Store date is

A date/time workflow variable to store the result of the calculation.

Store IOS 8601 date string

A text variable that contains the date in the XML friendly ISO 8601 format.

The text variable to store the date as a string in ISO 8601 format: YYYY-MM-DDThh:mm:ss.sTZD (1997-07-16T19:20:30.45+01:00). This format helps eliminate confusion between countries that use different date formats.

For more information about this format, see the W3C article: http://www.w3.org/TR/NOTE-datetime

Related information

Find, add, and configure actions