Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL for finding all tickets due tomorrow

Ben Weisman
Contributor
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 Champion
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 Champion
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