JQL Query for tickets resolved "last friday" regardless of the current day.

[Chris Buzon]

Hello Fellow Jira peeps.

I've been trying to figure out a query that is smart enough to identify Tickets resolved "Last Friday", regardless of the day it is today.

I've tried things like ResolvedDate = EndOfWeek(-3d) , and variations on the other date functions, but haven't found anything that works.

Just putting out a question to see if any other jira users have managed to logic their way through this.

(it's for a board quick filter).

Thanks!
Happy 2023!

[Guilhem Dupuy · Accepted solution]

Hi @Chris Buzon ,

I think it didn't work because of the "=" operator, which checks for an exact date and time (as the resolutionDate is a date and time field). I checked this on my Cloud instance and the following JQL should work :

resolutiondate <= endOfWeek(-10d) AND resolutiondate > endOfWeek(-11d)

You can then adapt the number of days depending on which day of the week is set as last, I think the default is Saturday surprisingly.

Let me know if it helps,

Guilhem

[Chris Buzon]

I'm an idiot!  That actually makes a lot of sense.  Thank you so much @Guilhem Dupuy , I'll go give that a shot.  I'm almost certain that'll work the way we want.

[Guilhem Dupuy]

Ahah lots of complexities in JQL so lots of ways to struggle sometimes 

Happy to help anyway!