JQL for due date between last friday and this friday

Question

Hi How to write JQL to pull issues with due>= last Friday and due<= this Friday? We don't want to use dates as JQL needs to be manually updated every week. i tried due>= startofweek(-5d) and due<= endofweek(-5d) but this gives a different set of issues compared to jql used with dates like due>=2018-10-12 and due<=2018-10-18 Any suggestions? Thanks

Alexey Matveev · Accepted Answer

Hello, startofweek begins from Monday for Europe and from Sunday for USA. That is why it should be due>= startofweek(-3d) and due<= endofweek(-2d) or due>= startofweek(-2d) and due<= endofweek(-1d) depending on your settings.

Bastian Stehmann · Accepted Answer

Hi @KRC,

I think your approach is right, but why do you use -5d in both cases.

Here in Germany, where startofWeek would be considered monday, I think this should give the right result:

due >= startOfWeek(-3d) and due<=startOfWeek(4d)