Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL - search within timefames

Patrick van der Rijst
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 24, 2021

Hi there!

I have two JQL statements that searches for a specific time frame.

1) Created = Between 16:00 and 01:00 every weekday
created >= startOfWeek("+1d") AND created <= startOfWeek("+6d")) AND (created >= startOfDay("+16h") AND created <= startOfDay("+25h"

2) Created = Between 01:00 on a Saturday morning and until 01:00 on a Monday morning

created >= startOfWeek("-1d") AND created <= startOfWeek("+2d") ) AND (created >= startOfDay("+1h")

 

I'm unsure if the "til 1:00 on a Monday" is even possible? Suggestions are more than welcome! :) 

0 answers

Suggest an answer

Log in or Sign up to answer