You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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 ?
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.