Jira Snippet Library: JQL - Time and Status

[#1]

Here are some time and status related examples.

Specify time using m for minutes, h for hours, d for days, or w for weeks. 2400 minutes is the same as 40 hours, 5 days, or 1 work week. Use any of those formats. (Ex: 2400m = 40h = 5d = 1w)

Use dates in the format:

• yyyy/MM/dd

• yyyy-MM-dd

Add hours and minutes in the format:

• yyyy/MM/dd HH:mm

• yyyy-MM-dd HH:mm

You can also use relative functions like startOfMonth or endOfMonth. There’s a start and end function for: month, week, and year.

Here are some examples:

Recently created items

• created >= -4w ORDER BY created DESC

• created > "2026/01/01"

• created > "2026/01/01 09:30"

Incomplete items

• type = Bug AND (status = Open OR status = “In Progress”)

• type = Bug AND status IN (Open, “In Progress”)

• type = Bug AND status != (Done)

• type = Bug AND status NOT IN (Closed, Done)

• type = Bug AND statusCategory != Done

• type = Bug AND resolution is empty

Tip: You must enclose all multi-word values in quotes. E.g., “In Progress”

Recently completed items

Use relative dates and functions.

• status = Done AND resolved >= -1w

• status = Done AND resolved >= startOfMonth()

Use two date clauses to find items resolved between two dates.

• status = Done AND resolved >= "2026-01-01" AND resolved <= "2026-12-31"

Restrict by resolution type.

• status = Done AND resolution in (Declined, Duplicate)

Items due soon

• due < now()

• due < 1d and resolution is empty

---

Back to intro or article list