Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-64403

Allow comparison of Date Fields



    • Suggestion
    • Status: Closed (View Workflow)
    • Resolution: Duplicate
    • None
    • JQL
    • None
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.


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

      Issue Summary

      If a customer attempts to write a JQL that compares to date fields, this JQL is unacceptable by JIRA because it currently unsupported as our expected supports only specific dates in the format YYYY/MM/dd, startofmonth() or durations like "-3w" (refer to the Created section).

      Usage Scenario

      If a development team would like to compare or measure how many fixes were released before the scheduled due date, it would be great to be able to create a report that compares using JQL:

      releasedate < "due date"
      Existing Behavior

      JIRA would throw an error if you attempt to use the JQL as defined above as it would expect you to use the duration or actual date as described in the summary section.

      Expected Behavior

      JIRA would allow the user to compare JQL of 2 different date fields.


        Issue Links



              Unassigned Unassigned
              ijimoh Ismael Olusula Jimoh (Inactive)
              0 Vote for this issue
              2 Start watching this issue