This JQL function is used for searching project properties containing a date.

Quote-marks " must be used.


projectsWhereDateProperty(propertyName, operator, date) #Output: Issues



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 aa 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 .




Short description

JQL function to search for specific date properties.

Output

Label






Status
Tech review

Style guide