Creating filter to get issues between first Tuesday of last month and first Tuesday of this month?

[Brinda Tailor]

One of our teams wants to have a filter to see all the issues created between first Tuesday of previous month and first Tuesday of current month.

Is there a way to create such a filter? I planned on using created >= -30d but that wouldn't give accurate results.

Use case for this filter: Every first Tuesdays of the month, the team meets with stakeholders to discuss issues that came up between the two meetings. I do not want to create a hard coded filter to modify dates every month. Is there a solution?

[Bill Sheboy · Accepted solution]

Hi @Brinda Tailor 

I do not believe that is possible with the out-of-the-box features of JQL.

You may find the startOfMonth() or the startOfWeek() and add some days, but there is no function for the "first Tuesday of a Month" with JQL.  https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfMonth--

As work-arounds, you could...

• spend money: 
  • Investigate marketplace apps which add features to JQL or dashboard gadgets with better reporting controls
• build your own:
  • simple
    • Create an automation for JIRA rule to return the issues in the date range.  Automation rules have better date handling than JQL, and so could dynamically construct that query based on the current date / time.  This could send an email, or message, with the list of issues.
  • more complicated
    • Create a saved filter for a date range, and using a scheduled automation rule that runs once per month, update the filter dynamically for the dates by calling the REST API functions.  One advantage of this approach is the updated filter could be used in a dashboard.

Kind regards,
Bill