Can you compare today to a specific date

Question

I'm trying to filter issues with this.

LOGIC: If today's date is between Feb. 8 and Feb. 21 show me my issues in sprint 5325

Assignee = currentUser() AND startOfDay() >= '2024/02/08' AND startOfDay() <= '2024/02/21' AND Sprint = 5325 AND Status not in (Closed, Done, Cancelled, Canceled)

Tom Scoggin · Answer

I will take a look and see if it will work.

Wladimir Walter Quiroz Galeas · Answer

OK. there are different ways to do that:

1.- By using a two-dimensional Filter Gadget

2.- If you have Jira Plans. You can create a "Team View" and then you can see all the tickets for each one of the sprints like this:

I hope it works for you

Tom Scoggin · Answer

I have a dashboard that shows assigned work for the next sprint. So I'm trying to show assigned work for the next sprint. If today falls within sprint 1 then show work assigned to the next sprint. Sprint 5235 is the next sprint.