addTime() | Decadis App Help Center

Number

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

Bash

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
Bash `addTime(2020/12/01 01:00, 8 * {HOUR} + 31 * {MINUTE}, "my_calendar", LOCAL)`	This example returns a timestamp representing: "2017/12/04 10:01"
Bash `addTime(2020/04/20 20:30, - 5 * {HOUR}, "my_schedule", LOCAL)`	This example returns a timestamp representing: "2017/04/20 13:00"

Parser expression

Description

Bash

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

This example returns a timestamp representing:

"2017/12/04 10:01"

Bash

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

This example returns a timestamp representing:

"2017/04/20 13:00"

Parameters used in this function

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.

Bash

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
Bash `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.

Parser expression

Description

Bash

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.

Parameters used in this function

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