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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.