Forums

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

>= operator is not working on date field

Sabby.Kulshreshtha November 6, 2023

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.
November 6, 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.

Sabby.Kulshreshtha November 7, 2023

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.
November 7, 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.
November 6, 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. 

0 votes
John Tester November 6, 2023

@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
Community Champion
November 6, 2023

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.

Sabby.Kulshreshtha November 7, 2023

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