JQL query for a Work Week

[Ashleigh Friloux]

I need a JQL query to show all issues that were update within a work week, Monday through Friday. I've tried different combinations of the startofweek and startofday but I cannot seem to get it work.

Thanks

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

You can use startOfWeek(1d), endOfWeek(-1) and so on, depending on your work week. 

For example:

updated >= startOfWeek(1d) and updated < endOfWeek(-1d)

[Ashleigh Friloux]

So 1d is Monday and -1d is Friday? Im not sure how that is

[Jobin Kuruvilla [Adaptavist]]

1d is one day from start of week. 2d is 2 day after start of week and so on. Similarly -1d is 1 day before end of week. 

[Ashleigh Friloux]

Thank you! makes sense

[Hopkins_ Kenyon]

But how would you write this for last week? Last week being last Monday thru last Friday. I'm even good with Sun-Saturday. I just need it to be the previous complete week and not the last 7 days.