Use case

This calculated field will return the predicted resolution date of the issue by adding the remaining estimate to the current date and taking business hours into consideration.

To achieve this, a calendar is used to specify the actual business hours.

Configuration

Create a new Calculated Date-Time Field (by JWT) custom field and name it appropriately.

Providing a description will help you to identify what the custom field does, but this step is optional.

Parser expression

Add the following expression:

Date/Time expression for Calculated date/time field:
{issue.remainingEstimate} != null ? addTime({system.currentDateTime},({issue.remainingEstimate} * {MINUTE}), "working-hours", LOCAL) : null
more info...

working-hours is the JWT calendar used to specifiy the actual business hours. In this example we will assume a simple eight-hour working day:

Calendar expression for 'working-hours':
MON-FRI {
   08:00-17:00;
}

Display Format

Format type

Choose Date Time Picker

Add the field to the relevant view screens.

Remember: All calculated fields are read-only and cannot be manually updated on a create or edit screen.

Check the results

Once configured and added to an issue screen (e.g. for all stories), the result will look like this:



If you still have questions, feel free to refer to our support team.