Dynamic Date in JQL

[Dietrich]

Hi all,

We have to do some reporting out of Jira on the 26th of each month and make use of the below JQL:

category = ITSM AND issuetype in standardIssueTypes() AND created >= 2024-06-26 AND created <= 2024-07-26

Each month, we need to manually change the month values by +1. So next month the query will look like this:

category = ITSM AND issuetype in standardIssueTypes() AND created >= 2024-07-26 AND created <= 2024-08-26

Is there a better way to do this, so the month value automatically updates itself?

Thank you

[Bill Sheboy · Accepted solution]

Hi @Dietrich 

Creating a specific, dynamic date for filtering is not possible with the built-in features of JQL.  It could check using month adjustments to "now" or functions like startOfMonth(-1), etc.: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfMonth--

Some of the workarounds you could try depend upon how you are doing the reporting.  Let's assume you need to update a saved filter, such as for use in a dashboard, filter subscription, or to just run it manually.  In that case, you could...

• investigate the Atlassian Marketplace for possible addons to JQL to add such features
• investigate the Atlassian Marketplace for more advanced reporting apps
• create a Jira Automation rule which runs on a monthly scheduled and uses the REST API to update the saved filter

Kind regards,
Bill