Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Wierd date range filter behaviour not really working

Dear all,

I have the following filter view in place which is suppose to extract only records created last month ( in May), but as you can see from below picture it includes as well records from June.


Any idea why and what is wrong ?

1 answer

Hi Calderara,

this is working as intended as the (-1) indicates the start of the month -1 month, so every ticket that was created from the start of May in your case. If you want only tickets from June leave the brackets empty startOfMonth(), and if you want tickets that were created in May add the condition created < endOfMonth(-1)


Edit: It displayes the ticket as they were also created after the 01.05. since you didn't set an end date in your query.

Best regards,


Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you