Forums

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

Is there anyway to modify jql query keyword now() with custom argument, like -3 days in the argument

Laxmi
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!
February 21, 2024

I want to set up a jql query for now() when I search for issues that expired 2 days before today. I dont think I can use startofday as it will give me only 48 hours as I want to view issues from past 300 days to 2 days ago

2 answers

1 accepted

2 votes
Answer accepted
JM Perrot
Community Champion
February 21, 2024

Hello @Laxmi 

I'm not sure to understand what you want but if "startofday" doesn't contain the day you want, did you try "endofday()" ?

due <= endofday(-2d) AND due >= startofday(-300d)
1 vote
Bill Sheboy
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.
February 21, 2024

Hi @Laxmi -- Welcome to the Atlassian Community!

In addition to the other answers provided, I recommend reviewing this free training and documentation from Atlassian on creating JQL queries.  The training includes exercises to help build skills in making queries like you asked about.

https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill

Suggest an answer

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

Atlassian Community Events