This JQL function is used for searching for users by checking against user properties that contain date or date-time values.

usersWithDateTimeProperty(propertyName, operator, value, format) #Output: User list
Parser expressionDescription
assignee in usersWithDateTimeProperty("day_off", "<", "2021/11/03", "dd/MM/yy")
This example returns all issues where the Assignee's property day_off is before 2021/11/03, and it's written in the format dd/MM/yyyy.
reporter in usersWithDateTimeProperty("birthday", ">=", "1997/09/16 11:30", "MM-dd-yyyy [hh:mm]")
This example returns all issues where the Reporter's property birthday is after or the same day as 1997/09/16 11:30, and it's written in the format MM-dd-yyyy [hh:mm].

Parameters used in this function

ParameterInput (data type)Description
propertyName

The name of an user property containing a date or date-time value
operator

A valid comparison operator

value

The value to compare with the property.

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

format

The date or date-time format in which the property value is written. Any format is allowed.

This function returns .

Short description

Search for users by checking on their date or date-time properties.

Output

Label


Status
Tech review

Style guide