Wierd date range filter behaviour not really working

[Calderara Serge]

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 ?

[Igor Dugalic]

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,

Igor