Filter from 15th of Previous Month

[Vivienne Clark]

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]

@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]

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