Date Compare JQL functions Cloud

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.