Date Compare JQL functions Cloud
: available in Issue Navigator.
compareTwoDates()
**Applies to “Date” type of fields.
Examples
issue in compareTwoDates("query", "Date Field Name 1", "Date Field Name 2", "Operation")
issue in compareTwoDates("project = myProject", "Planned Start", "Actual Start", "<")
finds the issues where the actual start date is later than the planned start date.
compareTwoDateTimes()
**Applies to “Date & Time” type of fields.
Examples
issue in compareTwoDateTimes("query", "Date Field Name 1", "Date Field Name 2", "Operation")
issue in compareTwoDateTimes("project = myProject", "Planned Start", "Actual Start", "<")
finds the issues where the actual start date is later than the planned start date.