usersWithDateTimeProperty()

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

Syntax

usersWithDateTimeProperty(propertyName, operator, value, format) #Output: User list

Parser expression	Description
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, 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, written in the format MM-dd-yyyy [hh:mm].

Parameters used in this function

Parameter	Input (data type)	Description
`propertyName`	TEXT	The name of a user property containing a date or date-time value
`operator`	TEXT	A valid comparison operator
`value`	TEXT	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`	TEXT	The date or date-time format in which the property value is written. Any format is allowed.

This function returns a USER LIST.

Variant supporting 12-hr and 24-hr format.

Syntax

usersWithDateTimePropertyValue(String property, String comparator, DateTime value) #Output: User list

Parser expression	Description
assignee in usersWithDateTimePropertyValue("day_off", "<", now())	This example returns all issues where the assignee's property day_off is before Today, written in the format MM-dd-yyyy [hh:mm]. (12-hr or 24-hr format)

Parameters used in this function

Parameter	Input (data type)	Description
`String property`	TEXT	The name of a user property containing a date or date-time value.
`String comparator`	TEXT	A valid comparison operator.
`DateTime value`	TEXT	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] in 12-hr or 24-hr format.

This function returns a USER LIST.