Date Functions

You can use Date functions, for instance now(), startOfDay() etc, anywhere you would use a date. Supported functions include:

• now()
• startOfDay()
• startOfMonth()
• startOfWeek()
• startOfYear()
• endOfDay()
• endOfMonth()
• endOfWeek()
• endOfYear()

Some arguments will need to be quoted. For example, if you want to say one week before the start of the month, you would write startOfMonth('-1w').

Differences with ScriptRunner for Jira Server

You can read about the differences between ScriptRunner for Jira Server and Jira Cloud advanced JQL functions in the side-by-side comparison here. There is also a Feature Parity and Script Alternatives table which outlines feature differences that includes JQL functions.

Functions startOfWeek() and endOfWeek() return Monday as the first day of the week and they take time in UTC. If you use Sunday instead of Monday, you can use -1d period modificator, e.g. startOfWeek('-1d').

Time windows

Use time windows on both side of the expression. For example, if you needed to find issues resolved before or up to six days after their due date:

issueFunction in dateCompare("project = DEMO", "resolutiondate +1d < duedate +1w")

Created and updated

Use created or updated to find issues based on when they were created or updated. For example, to find issues that were resolved within two weeks of creation, use:

issueFunction in dateCompare("project = DEMO", "created +2w > resolutiondate ")

Datetime custom fields

Use date and datetime custom fields. For example:

issueFunction in dateCompare("project = DEMO", "resolutiondate > customfield_10500")

(where customfield_10500 is the name of a 'date' custom field).