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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Filter by Duedate not working for Duedate+20Years


i habe a simple filter in jira to list all Issues where Duedate <= Now()

if i have issues where the Duedate is between now and 31.12.2042 then the Issue is not in the result set.

if i change the date to 1.1.2043 and above then the issue is in the result set.

It seems that JIRA Time Filter dont work for timestamps which are "too much" in the feature, maybe now+20 Years ?

Anybody knwo this problem and how to solve it?


3 answers

hi @Fabio Racobaldo _Herzum_ 

i think a picture will help to understand the problem:

with duedate <= now() jira find also issues which are in the future and i think this is a bug.


it seems that jira is working fine with timestamps in the near future (between now and < "now+20 years") but not with timestamps which are far away in the future, like > "now+20Years") ...

I think this isn't a solution for the Problem.

because i dont waht to have all the issues in my resultset which duedate is <= startOfYear(42)

i want all issues with duedate <= now()

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 13, 2023 • edited

Hi @Darko Maraz ,

did u try the following jql ?

duedate >= now and duedate <= startOfYear(20)


Suggest an answer

Log in or Sign up to answer