Query for date

[Ratheesh.R]

How to get all issues for a date field which is above the end of current week?

[Pramodh M · Accepted solution]

Hi @Ratheesh.R

JQL goes like this, (In this I have checked for a due date field, you may replace the field with the date field you have customized)

project = projectKey AND due >= endOfWeek()

Thanks,
Pramodh

[Ratheesh.R]

Thank you so much Pramod. it works. would you happen to know how i can put a time period for the dates as well?

example - to find out if  list of issues for a date field which starts from end of current weeks and falls in 4 upcoming weeks and 8 up coming weeks?

[Pramodh M]

Hi @Ratheesh.R  Glad!

We would have to specify that with the number 

For example, for issues due by end of 4 weeks, the JQL is

project = projectKey AND due >= endOfWeek(+4)

 And for 8 weeks, JQL is

project = projectKey AND due >= endOfWeek("+8")

 Thanks,
Pramodh

[Pramodh M]

FYI,

We have to submit the number in quotes.

project = projectKey AND due >= endOfWeek("+4")