JQL Query for Issues by Due Date

[Gareth Chong]

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

[Nic Brough -Adaptavist-]

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()

[Leo]

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