Dynamic Date Range - Monday to Sunday

Peter Ballistreri

Hi there, I would like to run a JQL query showing items created/updated within the past working week, essentially Mon-Sun (when running the query during the following week). Eg. running the query today (18/09) I would expect to see items created/updated between Monday 08/09 through to Sunday 14/09.

So far, I've come up with: 

project in (RTO) AND status changed from Open to (Resolved, Closed) AND updatedDate > -7d AND createdDate > -7d

This gives me the previous 7 days, regardless of when I'm running the query. I need something more finite.

Simon Kegel //SEIBERT/MEDIA

Hey Peter,

how about using the JQL functions like StartOfWeek().
"project in (RTO) AND status changed from Open to (Resolved, Closed) AND updatedDate >= StartOfWeek(-7d)"
Monday to monday in this case.

Hope this could help.
 
Greets
Simon