JQL Query to isolate due dates

[Josh Kitterman]

I am having issues developing an advanced JQL string for purposes of isolating stories due within a giving month.  I can get my order of operations correct but looking to see if I can segment out by future months and if there is a date format component I need to insert into the endofMonth() function.

[Sreenivasaraju P · Accepted solution]

Hi @Josh Kitterman ,

what do you mean by due within a giving month.

next 30 days or next month or current month.

you can try below queries as per your requirement

if next 30 days - duedate < 30d

by current month - duedate < endOfMonth()

by next month - duedate < endOfMonth(1)

due date in next month - duedate < endOfMonth(1) and duedate > startOfMonth(1)

[Josh Kitterman]

Thanks for that Sreenivasraju!  Gave me part of the JQL I was looking for and adapted from there!