Overview

View app on Atlassian Marketplace

Welcome to Time between date for Jira Cloud!

This application calculates the time between two dates from the issue fields. These can be either system fields - created, updated ... or any custom fields of the date time type. For example: Time to resolution - time between created and resolution date

The countdown is specified in the field settings (Start field). Each field dynamically changes its value with a certain frequency. Update rate depends on the time: the longer the time, the less frequently the value will be updated.

Simple configuration

Specify a working calendar and a couple of Issue fields such as date time. The application will automatically calculate the time between the specified dates and update additional information for searching and sorting.

More calculated info

The field will calculate several values at the same time.

• Time between dates (start and end) - goal time
• Time between dates (now and end) - left time.
• Time between dates (start and now) - time spent.

Left time and time spent - These values are calculated after the start date.

Business calendar:

The plugin can calculate the time according to the configured calendars. In fields and jql there are corresponding settings. You can create an unlimited number of calendars and use it in any contexts and projects.

JQL for time between dates

You can search and sort tasks by the "Time between dates" fields. This allows to create queue/filters according to the time metrics.

Fields are also available for export in different formats, which allows you to use your favourite reporting tools: excel, rest api, dashboards, etc.

1. Create a work calendar. To do this, go to the adjacent tab: Calendars.
2. Create fields to track the time between issue dates. To do this, go to the adjacent tab: "Time between dates fields".
3. Configure JQL Queries. You can display new fields in the JQL navigator and dashboards. (📌 Clickable examples will be here after creating the field)
   • "DATE:FIELD_NAME" = startOfDay()
     Available DATE values:
     • "started:FIELD_NAME" > startOfDay() - start date is drilled from the start field specified in the settings
     • "stopped:FIELD_NAME" > startOfDay() - stopped date is drilled from the stopped field specified in the settings
     For example: "started:FIELD_NAME" > startOfDay() - to search by start date.
   • "state:FIELD_NAME" = STATE - to search by state of "Time between dates" field.
     Available STATE values:
     • "state:FIELD_NAME" = active - The state becomes active after the start date.
     • "state:FIELD_NAME" = inactive - The state becomes inactive, before the start date and after the end date.
     For example: "state:FIELD_NAME" = active - to search active timers.
   • Search by hours and minutes:
     • "hours TIME:FIELD_NAME" > 2 - to search by time in hours.
     • "minutes TIME:FIELD_NAME" > 45 - to search by time in minutes.
     Available TIME values:
     • "hours TimeSpent:FIELD_NAME" > 2 and "minutes TimeSpent:FIELD_NAME" > 45
     • "hours LeftTime:FIELD_NAME" > 2 and "minutes LeftTime:FIELD_NAME" > 45
     • "hours GoalTime:FIELD_NAME" > 2 and "minutes GoalTime:FIELD_NAME" > 45
     Combined this conditions:
     "hours TIME:FIELD_NAME" > 2 AND "minutes TIME:FIELD_NAME" > 45 will search for issues that time more than 2 hours and 45 minutes.
   • "time in hours TIME:FIELD_NAME" > 1.5 - to search by time in hours. You can enter a fractional number. The all time will be converted to hours in decimal notation.
     Available TIME values:
     • "time in hours TimeSpent:FIELD_NAME" > 1.5
     • "time in hours LeftTime:FIELD_NAME" > 1.5
     • "time in hours GoalTime:FIELD_NAME" > 1.5
     For example: "time in hours TimeSpent:FIELD_NAME" > 1.5 - find timers that have counted down more than an hour and a half.
   • "time in minutes TIME:FIELD_NAME" > 90 - to search by time in minutes. The all time will be converted to minutes.
     Available TIME values:
     • "time in minutes TimeSpent:FIELD_NAME" > 90
     • "time in minutes LeftTime:FIELD_NAME" > 90
     • "time in minutes GoalTime:FIELD_NAME" > 90
     For example: "time in minutes LeftTime:FIELD_NAME" > 90 - find timers that have more than 90 minutes left until the end.
   • 'For sorting, you can use any of these fields with the obligatory indication of 'ASC or DESC
     • ... ORDER BY "minutes TimeSpent:FIELD_NAME" ASC
4. Information about scheduled work on the servers or a failure will be displayed on this page(Start page). Additional notifications are available on the page: Status page
5. Please contact support in case of difficulties.

---

Time between dates - How to create field?

Next →