JQL Filter for tickets created since last x date

Question

Need help finding a JQL filter to show all tickets created after Wednesday of the previous week

Gunjan Kumar_xl3r1p · Answer

Hi @James Zalewski Welcome to Atlassian Community

Try this JQL:

* Since a specific date: created >= "2026-03-01"
* Between two dates: created >= "2026-03-01" AND created <= "2026-03-31"
* last 7 days: created >= -7d

Aaron Pavez _ServiceRocket_ · Answer

Hi @James Zalewski

Is this for all Wednesdays of the month? Or just the past Wednesday?

the past Wednesday and wednesday till sunday 29th.

createdDate > 2026-03-25
createdDate > 2026-03-25 and createdDate < 2006-03-30

or

created > "-7d"

The -7 day works if you run this on Wednesday (will check everything created since past Wednesday)

a way to run and show all Wednesdays of the month with JQL? Not possible.

Automation can help you with that with smart values

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Regards

Arkadiusz Wroblewski · Answer

Hello and welcome to the Community @James Zalewski

If you mean everything created after Wednesday of the previous week:

created >= startOfWeek("-4d")

That works when your Jira week is effectively Sunday-based, because Atlassian documents startOfWeek() as starting from the first day of the current week, with Sunday as default when ISO8601 is not enabled.

If your site is using Monday as the start of the week, then the offset changes:

created >= startOfWeek("-5d")

And if you just want a simple rolling filter from “last 7 days”:

created >= startOfDay("-7d")