Difference between two dates in business days

Use case

This calculated field will display the difference between two dates reflected in Date picker fields in business days.

🗒️ Prerequisites

Set up a calendar

Add a new calendar in Jira administration > Manage apps > Calendars

Name the calendar with a recognizable name as in the following example.

Bash
Business Hours

Introduce a relevant expression in the Specification field like the following one:

Bash
MON-FRI{09:00-17:00;}

⚒️ Configuration

Create a new Calculated Text Field (by JWT) custom field and name it properly.

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

Parser expression

Add the following parser expression:

Bash
formatWorkDuration(timeDifference({issue.cfaaaaa},{issue.cfbbbbb},"Business Hours",LOCAL))

Do not forget to replace

{issue.cfaaaaa} and {issue.cfbbbbb} with the field codes of the appropriate custom fields.

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.


📚 Related use cases