Skip to main content

Devbit

Jira JQL Filter: Issues with a date field value in the next upcoming month

For some Jira dashboard filters it can be useful to list issues with a certain date field (e.g. the duedate if you're planning your work ahead) inside the upcoming (or any future upcoming) month.
AND "[yourDateField]" >= startOfMonth("+1") AND "[yourDateField]" <= endOfMonth("+1")

Issue:

For some Jira dashboard filters it can be useful to list issues with a certain date field (e.g. the duedate if you're planning your work ahead) inside the upcoming (or any future upcoming) month.

Solution:

You can utilize the startOfMonth and endOfMonth operators for this, followed by a number specifying how many months ahead or behind you want to look. ("+1") in the example means next month. Now if you view your filter on any day in May, you will see all issues due in June, and if you look at it in June, you will see everything due in July. You can also use ("-1") to see what would have been due in the past month. Don't forget to exclude closed issues from your filters.

Profilfoto Henjo Völker

Henjo Völker

Projektmanager / Redaktion

Ihre Drupal-Website zukunftssicher machen

Wir prüfen Ihr System und zeigen, was Sie für AI, Wartung und Upgrades brauchen.