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
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)
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
It looks like you're new here. Sign in or register to get started.