Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

>= operator is not working on date field

Hi

I am trying to create a filter for issues created date >= 5d.

JQL recognises the <= operator but not the greater than equals.

 

What can be used as an alternative in this case?

4 answers

0 votes
Muhammad Moazzam Hassan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 06, 2023

Created >=5 Days means you are searching the issues in future :-D

>= sign will use for dates in the finding of Due Dates, End Dates which you can define yourself.

Created date is automatically added once the issue is created so whenever you have to search issues from created you have to go on past and have to use - sign like created >= -30d this query will fetch the issues which are created in last 30 days.

Hi Muhammad,

I am trying to get the issues created 5+ days back from today.

Muhammad Moazzam Hassan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 07, 2023

then the query will be ,

created >=-5d and Created < -4d, It will only get those issues who were created 5 days ago.

0 votes
Thuan_ Do Dang
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 06, 2023

Hi @Sabby_Kulshreshtha ,

I have checked the JQL and it's right syntax

JQL_1.png

However, there's no result because of wrong logic. 

@Sabby_Kulshreshtha This is a great resource for the JQL functions you're looking for: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/ 

John 

0 votes
Dan Breyen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 06, 2023 • edited

Hi Sabby, are you looking for issues that have been created within the last 5 days?

If so, try this: "created >= -5d"  

This is saying go back 5 days from today and select anything where the created date is greater than that.  

Hope that helps.

Hi Dan,

I am trying to get the issues created 5+ days back from today.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events