endOfQuarter()

Owned by Jack Nolddor
Last updated: Oct 12, 2019
1 min read

Description:

Perform searches based on the end of the current quarter of year.
See also: startOfQuarter()

Syntax

endOfQuarter()
endOfQuarter(duration)

Where 'duration' is an optional increment of (+/-)nn(y|q|M|w|d|h|m).
If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfQuarter("+1") is the same as endOfQuarter("+1q").
If the plus/minus (+/-) sign is omitted, plus is assumed.

Available sincev1.8.0-RELEASE
Supported fieldsCreated, Due, Resolved, Updated, custom fields of type Date/Time
Supported operators

= , != , > , >= , < , <=
WAS* , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED*


* Only in predicate 

Unsupported operators~ , !~ IS , IS NOT , IN , NOT IN


Examples:

• Find issues due by the end of this quarter of year:

due <= endOfQuarter()

• Find issues due by the end of next quarter of year:

due <= endOfQuarter("+1")

• Find issues due a month after the end of current quarter of year:

due <= endOfQuarter("+1M")

Real World Use Cases:

· JRASERVER-20359 - Expand JQL to support date-oriented functions (Month, Day, Year) so there is more precision (by Betsy Walker)
· fixversion = all releases within a date range or quarter (by Luke Hale at ATLASSIAN Community)



JQL Function Reference