Filter from 15th of Previous Month

Question

Hello,

I want to create a filter that gives all tickets created from the 15th of the previous month. This essentially gives a monthly report on the 15th day of each month, as opposed to at the start of every month.

Thanks

Brant Schroeder · Answer

@Vivienne Clark Welcome to the Atlassian community

What @Bill Sheboy stated is correct.  There is not a way to go back a month and then add 15 days to that with the delivered functionality.  You could add createdDate > startOfMonth(-16d) to your JQL.  This would give you the 15th for 7 of the 12 months but would be off for any month with less than 31 days.  5 months would have issues from one or two additional days.

Bill Sheboy · Answer

Hi @Vivienne Clark -- Welcome to the Atlassian Community!

That is not possible with the built-in features of JQL.

Some possible workarounds are:

* investigate the Atlassian Marketplace for addons to JQL which add that capability
* investigate the Atlassian Marketplace for more advanced reporting options
* create an automation rule with a scheduled trigger which edits a saved filter using the REST API to update the filter for the dates.  (Essentially, the rule has fixed dates that update once per month.)

Kind regards,
Bill