Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Need help with JQL to find dates up to three days from today

Kel Hill
Kel Hill
Contributor
October 12, 2021

I have a custom date field and need a filter that pulls in only issues in which that date field is not blank AND the date selected is not more than three days into the future.

Any help on query syntax appreciated.

Answer
Watch
Like Be the first to like this
5149 views

1 answer

1 accepted

3 votes
Answer accepted
Jack Brickey
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.
Become a leader
October 12, 2021

Project = abc and “my date field” is not empty and “my date field” < startofday(3d)

View More Comments
Jack Brickey
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.
Become a leader
October 12, 2021

You may will want other conditions e.g. unresolved…

Project = abc and resolution is empty and “my date field” is not empty and “my date field” < startofday(3d)

Like
Kel Hill
Kel Hill
Contributor
October 14, 2021

Thank you so much!

Like
Vitaliy Levushkin
Vitaliy Levushkin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
December 19, 2023

Thanks! It helped me too

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events