Custom Filters: Tickets due next month

[Zack Lane]

Hi,

I'm trying to create a custom filter for my board to identify tickets that are due next month. It's not specific to a month so it can't be hard coded in. Is there a way to do this without using added macros or other features that likely need to be enabled by the system admins. I am just a regular user of Jira at my company. I've used "duedate <= endOfMonth()" so far but can't figure out what else to add to see only next month.

Thank you for your help!

Zack

[Bill Sheboy · Accepted solution]

Hi @Zack Lane -- Welcome to the Atlassian Community!

You are on the correct path, using functions such as startOfMonth() and endOfMonth():

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfMonth--

Those allow incrementing the value, such as with startOfMonth("+1")

For example, for issues in your project with a Due Date during the next calendar month, that could be this:

project = yourProject
 AND duedate >= startOfMonth("+1")
 AND duedate <= endOfMonth("+1")
 ORDER BY duedate ASC

Kind regards,
Bill

[Zack Lane]

Bill,

This did it! This is exactly what I couldn't figure out on my on. I couldn't figure out the correct placement of the +1 & didn't realize the quotes were needed. Thank you very much.

The Order by duedate asc didn't seem to change anything when applied. It didn't give me an error. Rather it just didn't change the order of the tickets when that was applied. I'm not worried about that though considering I don't need that.

Thanks again your quick help!

Zack