This JQL function returns projects with specific properties containing a date.

Quote-marks " must be used.

projectsWhereDateProperty(propertyName, operator, date) #Output: Text list
Parser expressionDescription
project in projectsWhereDateProperty("projectStart", ">", "2020/01/01")
This example returns a list of projects where the property called projectStart contains a date value greater than 2020/01/01, i.e. text {projectStart=2020/05/05'} is present in the project's description.
project in projectsWhereDateProperty("deadline", ">=", "-1w")
This example returns a list of projects where a property called deadline exists with a date value greater than a week ago.

Parameters used in this function

ParameterInput (data type)Description
propertyName

The name of a project property containing a text value.
operator

A valid comparison operator.

date

The date to be compared with the date stored in the project property. 

The date must have a format of yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm]

This function returns a .

Short description

Returns projects with specific properties containing a date

Output

Label

Status
Tech review

Style guide