JQL Query for Issues by Due Date

Question

Hi there,

I would like to search for issues due within the current month. ie. Aug 1st to Aug 31st.

Could I please ask for help on how to write it in JQL?

Thanks,

Gareth

Leo_e8op2r · Answer

Hi @Gareth Chong,

You'll have to use Due twice JQL query, but if you go with Basic option and choose  Due field it'll provide you 5 different options to choose parameter value, like more than, due in next, between and in range.....

but if you want to go with advanced jql query below query may fulfill your requirement

project = "Project Name" AND due >= 2019-8-1 AND due <= 2019-8-31

Nic Brough -Adaptavist- · Answer

Start with

dueDate >= startOfMonth() and dueDate <= endOfMonth()

You can add relative, absolutes and offsets into the () as well - startOfMonth(+12d) will give you the 12 day of the month to compare to, or endOfMonth(-1) means "end of last month"

Full docs at https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html#Advancedsearching-functionsreference-startOfMonthstartOfMonth()