Filtering between two periods of months

(0) Share

Report

Posted on by James2019

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

1122.Month.JPG

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

James2019 20 on at

Like (0)

Report

RE: Filtering between two periods of months

This solved my issue. Thanks!

Was this reply helpful? Yes No
Suggested answer

James2019 20 on at

Like (0)

Report

RE: Filtering between two periods of months

@Ravi Kashyap

This resolve my issue, Thanks so much

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Filtering between two periods of months

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.

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: Filtering between two periods of 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.

Was this reply helpful? Yes No
Verified answer

Srikanta Mahapatro 190 on at

Like (0)

Report

RE: Filtering between two periods of months

Hi,

You can filter two month by filter the created on by Last X months

Thanks,

Srikanta

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: Filtering between two periods of months

Hi,

you can select the last month from the operator. Remember to group as or condition.

Was this reply helpful? Yes No