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)
Thank you so much for the response! My weeks are rolling weeks however so I cannot specify exact dates other than Thursday to Thursday.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am glad,It helped :)
Have a nice day!
Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/JQL-for-Filter-by-date-range/qaq-p/947641
Hope it would help you.
Have a great day!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.