Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL Using Previous Month's Date

I need a query that will result in all Stories Resolved since the 25th of the previous month. The closest I can get is to use "resolved > startOfMonth(-7d)", but I'd prefer something more exact.

Any help will be greatly appreciated! 

1 answer

1 accepted

0 votes
Answer accepted
Peter DeWitt Community Leader Aug 11, 2022

@grassst , Not sure there is a way to jus specify the 25 of the previous month. You would need to actually specify the date. Something like this:

resolved >= 2022-07-25

using the yyyy-mm-dd notation


cheers -dewitt

Thanks @Peter DeWitt - Unfortunately I'm looking to use this query in multiple filters for multiple dashboards used by all of our company's Jira Projects. It's not feasible to change the specific date in all of these filters every month.

I appreciate your quick response.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events