Looking for a report to capture all tickets with a Createdate of last month?

Question

Joseph Chung Yin · Answer

@Frank Robb -

To supplement what @Jack Brickey stated, you can use the JQL above and export the issues into CSV for Excel to further diced/sliced to generate your report.

In addition, you can also save the JQL as a saved filter where you can reuse it again.

Hope this also helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

Jack Brickey · Answer

Hi @Frank Robb , how about this...

project = abc and created < startofmonth() and created >= startofmonth(-1)