View Source

This JQL function returns users by checking against their user properties that contain date or date-time values.

usersWithDateTimeProperty(propertyName, operator, value) #Output: Text list

Parser expression

Description

assignee in usersWithDateTimeProperty("day_off", "<", "2021/11/03")

This example returns all issues where the assignee's property day_off is before 2021/11/03.

reporter in usersWithDateTimeProperty("birthday", ">=", "1997/09/16 [11:30]")

This example returns all issues where the reporter's property birthday is after or on the same day as 1997/09/16 11:30.

assignee in usersWithDateTimeProperty("day_off", "<", "2020/08/15 [12:30]")

This example returns all issues where the assignee's property day_off is before 2020/08/15 12:30.

assignee in usersWithDateTimeProperty("day_off", "<", "2020/09/16 [12:30]")

This example returns all issues where the assignee's property day_off is before 2020/09/16 12:30.

Parameters used in this function

Parameter Input (data type) Description

propertyName

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

The property has to be saved in one of the following format:

operator

A valid comparison operator. Allowed operators are:

Operator	Description
=	Property must be equal to the specified value.
!=	Property must not be equal to the specified value.
<	Property must be lower than the specified value, meaning that the date saved date in the property must be before the specified date.
>	Property must be greater than the specified value, meaning that the date saved date in the property must be after the specified date.
<=	Property must be lower or equals to the specified value, meaning that the date saved date in the property must be before or equals to the specified date.
>=	Property must be greater or equals to the specified value, meaning that the date saved date in the property must be after or equals to the specified date.

value

The value to compare with the property, the following formats are accepted:

In case you use the format yyyy/MM/dd, the time part of the date will automatically be set to 00:00.

This function returns a

If you want to search for issues where a user as a specific text or numeric property value, have a look the the usersWithTextProperty or usersWithNumericProperty() function.

If you want to search for issues, checking only if a property is being set ignoring it's value, have a look the the usersWithProperty() function.

Short description	Returns users with specific date or date-time properties.
Output
Label