addTime()

This function adds time to a given timestamp based on a JWT calendar specification.

Syntax

addTime(timestamp, timeToAdd, calendarName, timeZone) #Output: Number

Assumption: A custom JWT calendar called "my_calendar" has been defined as follows:

MON - THU {
   08:00 - 15:00,
   16:00 - 19:30;
}
 
FRI {
    08:00 - 15:00;
}

Parser expression

Description

addTime(2020/12/01 01:00, 8 * {HOUR} + 31 * {MINUTE}, "my_calendar", LOCAL)

This example returns a timestamp representing:

"2017/12/04 10:01"

addTime(2020/04/20 20:30, - 5 * {HOUR}, "my_schedule", LOCAL)

This example returns a timestamp representing:

"2017/04/20 13:00"

Parameter	Input (data type)	Description
`timestamp`	NUMBER	The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
`timeToAdd`	NUMBER	Time to be added in milliseconds. Usually time macros will be used to convert to input to hours, days etc.
`calendarName`	TEXT	The name of the used JWT calendar.
`timeZone`	TIMEZONE	The time zone used for the calculation.

This function returns a NUMBER representing a timestamp.

Variant of the function where you can define an additional JWT calendar specification.

Syntax

addTime(timestamp, timeToAdd, calendarName, additionalSpecifier, timeZone) #Output: Number

Assumption: A custom JWT calendar called "my_calendar" has been defined as follows:

MON - THU {
   08:00 - 15:00,
   16:00 - 19:30;
}
 
FRI {
    08:00 - 15:00;
}

Parser expression	Description
dateTimeToString(addTime(2020/12/01 9:00, 25 * {HOUR}, "my_calendar", "2020/12/02 {;}", LOCAL), LOCAL, USER_LANG)	This example returns a timestamp representing: "04/Dec/20 13:00" A day consists of 10.5 hrs according to my_calendar. Adding 25 hrs to the specified timestamp, ignoring December 2nd, results in December 4th, 1PM.

Parameter	Input (data type)	Description
`firstDate`	NUMBER	The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
`dateToSubtract`	NUMBER	The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
`calendarName`	TEXT	The name of the used JWT calendar.
`additionalSpecifier`	TEXT	A text containing an additional JWT calendar specification.
`timeZone`	TIMEZONE	The time zone used for the calculation.

This function returns a NUMBER representing a timestamp.

The output can be written into any Jira field of type Date Picker ore Date Time Picker.

Another very common use case is to use this function in one of the JWT calculated date-time fields.

Use cases and examples

Use case	JWT feature	Workflow function	Field type	Automated action	Parser functions
Add days skipping weekends and holidays to a Date Picker field		Update or copy field values			addTime()
Predicted resolution date based on business hours			Date-time		addTime()