Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL for finding all tickets due tomorrow

Ben Weisman November 21, 2022

I want to be able to open this filter at any time of the day and see ONLY the tickets due the next business day. Is that doable?

2 answers

3 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 21, 2022

Hi Ben, you can use Duedate = startofday(1) to find issues where the duedate is always tomorrow. But this doesn't ignore weekends or holidays unfortunately. There isn't a way to ignore non-working days in JQL.

v0rts May 23, 2024

Thanks Jack! 👋

0 votes
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 21, 2022

@Ben Weisman -

Hi Ben:

Give this JQL a try -

DueDate >= startOfDay(1d) and DueDate <= endOfDay(1d)

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events