Report Filter Use Case: Monday - Sun, Next 2 Weeks | Community
Skip to main content
KierstenKollins
Community Advisor
KierstenKollinsCommunity Advisor
Community Advisor
April 3, 2026
Question

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

  • April 3, 2026
  • 1 reply
  • 11 views

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!

1 reply

Alex_Di
Alex_Di
Level 3
April 3, 2026

Hi ​@KierstenKollins 

 

Have you tried something like this? Starting with the built in filter of “Next Week” and making it +2

 

I used Planned Completion Date to filter on since I was not sure what field you were using. 

 

plannedCompletionDate=$$TODAYb+1w
plannedCompletionDate_Mod=between
plannedCompletionDate_Range=$$TODAYe+2w

KierstenKollins
Community Advisor
KierstenKollinsCommunity AdvisorAuthor
Community Advisor
April 3, 2026

I am using a custom date field. This filter unfortunately returns a Sun through Sat date range for the next 2 weeks. Thank you for trying to help. 

Terms & ConditionsAccessibility statement

Loading footer...