How to get total count of tickets in project queue?

Question

Using as a search string the last Friday to current or coming Friday?

Not wanting to use last 7days (project = SEC AND created >= -7d ) need to use calendar friday to friday.

thanks in advance

Gregory Van Den Ham_2hc9n5 · Accepted Answer

how about something like:

created >= endOfWeek(-1) AND created <= endOfWeek() ORDER BY created ASC

There's also the startOfWeek JQL that will get you the Monday, likely dependent on how you have Jira setup.

Norman Weekes_hcffa7 · Accepted Answer

Can also do:

project = SEC AND created >= "2018-09-14" AND created <= "2018-09-21"