timeDifference() | Decadis App Help Center

This function subtracts two timestamps using a JWT calendar. The time time difference will be returned in milliseconds.

Bash

timeDifference(firstDate, dateToSubtract, calendarName, timeZone) #Output: Number

Examples

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 `timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", LOCAL)`	This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar. The result will return milliseconds.
Bash `timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", LOCAL) / {HOUR}`	This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar. The result will return hours.

Parser expression

Description

Bash

timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", LOCAL)

This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar.

The result will return milliseconds.

Bash

timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", LOCAL) / {HOUR}

This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar.

The result will return hours.

Additional information

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 .
`timeZone`	timezone	The time zone used for the conversion.

Output

The function returns a number .

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

Bash

timeDifference(firstDate, dateToSubtract, calendarName, additionalSpecifier, timeZone) #Output: Number

Examples

Parser expression	Description
Bash `timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", "2020/05/20 {;}", LOCAL)`	This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar and additionally ignoring the 20th of May, 2020. The result will return milliseconds.
Bash `timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", "2020/05/20 {;}", LOCAL) / {HOUR}`	This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar and additionally ignoring the 20th of May, 2020. The result will return hours.

Parser expression

Description

Bash

timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", "2020/05/20 {;}", LOCAL)

This example calculates the elapsed time from issue creation to the current date and time using the calendar my-calendar and additionally ignoring the 20th of May, 2020.

The result will return milliseconds.

Bash

timeDifference({system.currentDateTime}, {issue.created}, "my-calendar", "2020/05/20 {;}", LOCAL) / {HOUR}

The result will return hours.

Additional information

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.

Output

The function returns a number

📚 Use cases and examples

Use case	JWT feature	Workflow function	Field type	Automated action	Parser functions
Difference between two dates in business days	(input latin letters)		Text		formatWorkDuration() timeDifference()
Automatically log work spent in a specific status		Log work			timeDifference()