JQL question

[sandeep]

Hi Team,

I am new to JQL and need to extract one month report of all the cards which were raised under our porject 

Could you please share me the JQL which fulfil my requirement 

Thanks

Sandeep

[Callum Carlile _Automation Consultants_]

Hi @sandeep , welcome to the Community!

If you are looking to create a rolling report of issues created in the last month, you can use

Project = ABC and created >= -30d

Or if you want to do a specific monthly range you would use

Project = ABC and created >= 2022-10-01 and created <= 2022-10-31

 Hope this helps!

[John Funk]

Hi Sandeep - Welcome to the Atlassian Community!

I would use Project = ABC and created >= startofMonth(-1) and created <= endofMonth(-1)

Because some months have 31 days and some 30 days and one 28 or 29 days.  

The code above will get the previous month.