Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-20727

Add ability to compare date fields using JQL

    XMLWordPrintable

    Details

    • UIS:
      8
    • Support reference count:
      27
    • Feedback Policy:

      Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Description

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      Atlassian Update – 4 January 2016

      Hi everyone,

      Thanks for voting and commenting on this issue. Your feedback is key to helping us understand how you use JIRA so we can continue improving your experience. We have reviewed this issue over the last few days; unfortunately we don't have any plans to support this in JIRA for the foreseeable future.

      Please remember that jira.atlassian.com is one of many inputs for the JIRA roadmap. You can learn more about our process here.

      I understand that our decision may be disappointing. Please don't hesitate to contact me if you have any questions.

      Regards,
      Dave Meyer
      dmeyer@atlassian.com
      Product Manager, JIRA Platform

      In JQL, it's currently only possible to compare dates either with a single fixed date, or with a function such as now(), currentLogin(), or lastLogin(). It would be useful to be able to compare two date fields to one another, as in this seemingly simple query:

      resolutiondate > duedate
      

      This would allow filtering for issues that were resolved after their due date.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              aatkins TonyA
              Votes:
              486 Vote for this issue
              Watchers:
              226 Start watching this issue

                Dates

                Created:
                Updated: