Search constraint based on day of the week

The community has really been great the past few weeks helping with advice. I’m hoping I can once again call on someone to offer some clarity if they’re familiar with what I’m trying to accomplish.

So what I need to do is send an email to my users every sunday with a link to a page in my web app. That page needs to display data in a repeating group that is constrained to the past seven days starting with the previous sunday.

I already know how to constrain data as it pertains to ONLY the last seven days. But let’s assume my user opens the link on Tuesday-- then there would be data for the current week going back 7 days.

If anyone can provide some assistance it would be greatly appreciated! Thanks in advance for your help.

Give this a whirl :slight_smile:

Wow. Thanks for this! Saved me a huge potential headache!!!