JQL Filter for tickets created since last x date

[James Zalewski]

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

[Arkadiusz Wroblewski]

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") 

[Aaron Pavez _ServiceRocket_]

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

[Gunjan Kumar]

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