Search issues during future date

[Wills_Chou]

Trying to search the issue during certain date by DURING.

For example, "Project Name" = Test AND project in (Atest,Btest) AND assignee was in membersOf(RDteam) DURING (2022-12-25, 2022-12-31)

In the future date, the result should be 0, but it still come out some issues.

How to change the JQL to get the right result?

[Wills_Chou]

I tried another keyword, operator, or function, it still doesn't work.

JIRA JQL seems not support the date in the future searching.

[Marta Woźniak-Semeniuk]

Hey,
take a look at the documentation for DURING operator
I thing using WAS in not the right choice here
1 - you are looking for the future dates
2 - it might have a problem with operating with Assignee being a member of the group.
Try using “IS” and use between dates instead of during.

[Wills_Chou]

I tried "IS" but it didn't work, the message showed that "IS" is for EMPTY use.

[Trudy Claspill]

Hello @Wills_Chou 

Welcome to the community.

What problem are you trying to solve by specifying a date range that is in the future?

[Wills_Chou]

Yes, the data range in the past wouldn't be a problem, problem only happens in the date range in the future.

[Trudy Claspill]

Why are you trying to search for issues based on the setting of a field value during a future date range? Since that date range is in the future it is illogical to search based on it.

[Wills_Chou]

Creating a report this year sorting by weeks.

From 01/01/2022 to 12/31/2022 every week, the issue search result would update automatically when the date arrive.

[Trudy Claspill]

I recommend that you have your Jira Administrator open a case directly with Atlassian Support about this, to find out if this is a bug or intended functionality.

https://support.atlassian.com/contact/#/