projectsWhereDateProperty()

This JQL function is used for searching project properties containing a date in format yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm].

Quote-marks " must be used.

Syntax

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

Parser expression	Description
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'.
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

Parameter	Input (data type)	Description
`propertyName`	TEXT	The name of a project property containing a text value.
`operator`	TEXT	A valid comparison operator.
`date`	TEXT	The date to be compared with the date stored in the project property.

This function returns TEXT.