This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can use two of these formulas where you adjust so that it always pulls the most recent Sunday and the Sunday before. Then you could leverage these in a filter tool where you compare your date column to these dates.
This uses DateTimeNow() which pulls the current date time, so this is a dynamic formula. The reason you are likely getting 7 records rather than 8 is because of the time component. In my example that I showed, I set the field to be a date. You could overcome this by wrapping the DateTimeNow() with a ToDate(DateTimeNow())