how to use between keyword in JQL

I am trying to retrieve the data between two dates. (date range)

I am using the below JQL and it is not getting the desired result. Please help me.

project = CCU AND issuetype in (Bug) AND "createdDate" <= '2015-01-01' AND "createdDate" >= '2015-01-31'

2 answers

Community moderators have prevented the ability to post new answers.

3 votes

Hello Vikram,

For your query, you wish to retrieve all bugs from project CCU created in January, am I right? In that case, your query should be like:

project = CCU AND issuetype in (Bug) AND "createdDate" >= '2015-01-01' AND "createdDate" <= '2015-01-31

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Bingo, thanks Rodrigo this worked. Thank you so much.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

You're welcome!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

What are you trying to search?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.