How would I write a JQL filter for Thursday at noon (last week) to Thursday 11:59am this week?

[Melissa Pelletier]

We run reporting on Fridays so I have to pull tickets on Thursdays and do follow ups.  In the past tickets that go in on Friday morning or after our Friday meetings somehow get overlooked.  I wanted to update our filter and cutoff time for my reporting in JQL to look for instances from last thursday at noon to this week thursday at 11:59a (essentially capturing a week's worth of tickets but for a Thursday to THursday with a specific time cutoff)

[Melissa Pelletier · Accepted solution]

Thank you so much for the response! My weeks are rolling weeks however so I cannot specify exact dates other than Thursday to Thursday.  

[Himanshi]

@Melissa Pelletier , You can give a try to updatedDate  >=  startOfWeek(-8)  and updatedDate   <= startOfWeek(-4) 

But with that you would not be able to define time range.

[Melissa Pelletier]

Thank you for this! this one worked   

[Himanshi]

I am glad,It helped :)

Have a nice day!

Cheers!

[Himanshi]

Hello @Melissa Pelletier ,

Welcome to the community.

You can try using :

project = "your-project-name" AND created >= "2023-01-01" AND created <= "2023-12-31" order by created DESC

For confined result about the time range try :

project = ProjectName and created >="yyyy/MM/dd 10:00" AND created <="yyyy/MM/dd 08:00"

I am sharing some community post to more references: https://community.atlassian.com/t5/Jira-questions/JQL-for-Filter-by-date-range/qaq-p/947641#:~:text=You%20need%20to%20use%20the,week%20here%20is%20example%20JQL.

https://community.atlassian.com/t5/Jira-questions/how-can-I-create-a-jql-filter-with-time-range-between-two-dates/qaq-p/675451

https://community.atlassian.com/t5/Jira-questions/JQL-for-Filter-by-date-range/qaq-p/947641

Hope it would help you. 

Have a great day!