Report Filter Use Case: Monday - Sun, Next 2 Weeks

Question

I have a use case where I need to be able to filter on a report to pull in Monday through Sunday for the next week into the following week. For example, dates would be 4/6 - 4/19. This report is ideally ran on Friday’s but could be run on a Thursday if there was a holiday.

I have set up a filter against my date field to show $$TODAY+3d between $$TODAYe+16d which does work if the report is only run on a Friday.

Is this possible to hard code or would I need to have the end user default to using a prompt to ensure accuracy.

Thank you!

AmyReilly · Accepted Answer

​@KierstenKollinsAgree with ​@skyehansen‘ssuggestion on DAYOFWEEK.You’ll want to create a custom field with the DAYOFWEEK function on your desired date. Then,I think you can add the filter you needwith an OR statement.Date is next week and day of week is >= 2ORDate is following week(*I used planned completion date as the example, but you can use whichever date you need)

Alex_Di · Answer

Hi ​@KierstenKollinsHave you tried something like this? Starting with the built in filter of “Next Week” and making it +2I used Planned Completion Date to filter on since I was not sure what field you were using.plannedCompletionDate=$$TODAYb+1wplannedCompletionDate_Mod=betweenplannedCompletionDate_Range=$$TODAYe+2w

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded