How to add filter "3rd week" and "4th week" on system view?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, Experts

I am looking for the way to filter "3rd week of this month" on system view. I know some filters such as "this week" and "next week", but there is no way to filter "3rd week" and "4th week" . Do you have any ideas to complete these filter ?

Thank you

Categories:

Other Functionality

All responses (3)

Answers (0)

LuHao 40,872 on at

Like (0)

Report

RE: How to add filter "3rd week" and "4th week" on system view?

Hi Takafumi,

Is your problem solved? Any other questions?

Don't forget to mark verified answers, which will help other users with the same theme. :)

Best Regards,

Lu Hao
LuHao 40,872 on at

Like (0)

Report

RE: How to add filter "3rd week" and "4th week" on system view?

Hi Takafumi,

There is no direct option to filter out the third week of the month, so we could only manually select the start date and end date.

For example, we want to filter the third month of March. (March 17 to March 23.)

We can set this up:

Date On or After 3/17/2019

Date On or Before 3/23/2019

Since this is a manually selected date, the range is different each year. So we need to change the start and end dates of this range every year.

Hope this helps.

Best Regards,

Lu Hao
Suggested answer

gdas 50,085 on at

Like (0)

Report

RE: How to add filter "3rd week" and "4th week" on system view?

Hi ,

Try with this , you change the "Next X Days" value as per your requirement . This will return only the current month and the days of week which you want.