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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 21, 2024

Hello @LAXMI PRASANNA NANNAPURAJU 

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 PRASANNA NANNAPURAJU -- 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