Hi All,
Im creating a system view for our cases. My goal is to capture the current month and last month. But cant find a way to filter two months.
Thanks in advance
*This post is locked for comments
Hi All,
Im creating a system view for our cases. My goal is to capture the current month and last month. But cant find a way to filter two months.
Thanks in advance
*This post is locked for comments
This solved my issue. Thanks!
@Ravi Kashyap
This resolve my issue, Thanks so much
Hi James ,
Using last 2 months will calculate last 60 days irrespective of month , you can go for last X months = 2 when you want to retrieve last 60 days records based on current date. What I understand from your question you want this month and last month data so go for filter like below .
SomeDate = This month OR SomeDate = Last Month
Here is the result , see handover date is only last two months.
Hi,
Best way to use the "Last X Month" operator and provide "2" as the value. In case you want to include more month say 3, simply change the value to 3.
Hope this helps.
Hi,
You can filter two month by filter the created on by Last X months
Thanks,
Srikanta
Hi,
you can select the last month from the operator. Remember to group as or condition.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156