Predicted resolution date (excluding weekends)

Use case

This calculated field will return the predicted resolution date of the issue by adding the remaing estimate to the current date and time excluding weekends.

To do so, a calendar is used to specifiy the actual working 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:

addTime({system.currentDateTime},({issue.remainingEstimate} * {MINUTE}), "businessHours", LOCAL)

more info...

businessHours is the calendar used to specifiy the actual working hours. In this example, a simple 8h-workday is assumed:

Calendar expression for 'businessHours':

MON-FRI{
   08:00-16: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:

SCREENSHOT

Related use cases

Use case	Field type	Label
Creation date of the linked epic	Date-time	STAFF PICK
Predicted completion date of an epic	Date-time	STAFF PICK
Predicted resolution date based on business hours	Date-time
Set the calculated field's visibility in function of the username, role or group	Date-time Number Text

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

Content

Space Tools