# SharePoint list view: show only items from the last 7 days > For the full documentation index, see https://250highstreet.com/llms.txt > Microsoft says [Today] math works on date columns, but you need the classic view editor. Here are the steps and a helper column fallback. Short answer: use a filter on a date column with \[Today\] and a number. Microsoft says: "You must use the classic view editor to filter columns using these keywords." Its page gives this example: Modified is greater than \[Today\]-7. ## What Microsoft says about \[Today\] Microsoft says: "The \[Today\] keyword works on date-based columns." And: "You can use math to get ranges that change with today's date." For documents changed in the last 30 days, it filters a date column for values at or after \[Today\] minus 30. To leave out the current day, add a second date filter that is less than \[Today\] and join the two with And. Microsoft also says: "It is not possible to use the \[Today\] or \[Me\] filters when filtering using a column header." So set \[Today\] filters in the classic view editor, as in the steps below. ## Steps in the classic view editor 1. Open your list. Select the view menu at the top right, then Edit current view. Exact names may differ on your screen. 2. Scroll to the Filters section and select "Show items only when the following is true". 3. Choose the date column, for example Created. 4. Set the operator to "is greater than or equal to". 5. In the value box, type \[Today\]-7. 6. Select OK at the top or bottom of the page. Microsoft says you can have up to 10 statements in a filter definition, and to put Or statements first, then any And statements. ## Between two dates For items from the last 7 days that are not in the future, add a second row: the same column, "is less than or equal to", value \[Today\], joined with And. Our advice, not a Microsoft rule: test with one old item and one new item to see that the edges are right. ## Why not a calculated column Do not try a "days ago" calculated column. The SharePoint formulas page says: "The TODAY and ME functions are not supported in calculated columns." See "[SharePoint calculated column with today's date](/guides/sharepoint-calculated-column-today/)". ## Fallback if the filter does not do what you need Our advice, not a Microsoft rule: add a Yes/No column named "Recent". Set its default value to No. A scheduled Power Automate flow runs each morning. It sets Recent to Yes on items inside the window and back to No on items that have aged out. Then your view filters on Recent equals Yes. Because the flow changes items, add a loop guard if another flow starts when an item is modified. ## What to avoid - Do not use the column header filter for \[Today\] or \[Me\]. - Do not store dates as text. A text column cannot use date math. - Do not look for an "is blank" operator. There is none. Our advice, not a Microsoft rule: test any rule for empty dates on a few blank rows first. For \[Me\], see "[Show each person only their own items in a SharePoint list view](/guides/sharepoint-list-view-filter-current-user/)". ## When to get help You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call. I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything. See trackers I built: [Tools I built](/portfolio/) ## FAQ ### How do I filter a SharePoint list for the last 7 days? Use the classic view editor, filter a date column, and set it greater than or equal to \[Today\]-7. Microsoft gives Modified greater than \[Today\]-7 as an example. ### Can I use \[Today\] in the column header filter? Microsoft says no. The \[Today\] and \[Me\] filters are not possible with a column header filter. ### How do I filter a SharePoint list between two dates? Add two filter rows on the same date column, one greater than or equal to the start and one less than or equal to the end, joined with And. ### How many filter statements can a SharePoint view have? Microsoft says up to 10 statements in a filter definition. ### Can a calculated column use today's date? Microsoft says the TODAY and ME functions are not supported in calculated columns. ## Sources - [Microsoft Support, Use filtering to modify a SharePoint view](https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4) - [Microsoft Support, Introduction to SharePoint formulas and functions](https://support.microsoft.com/en-us/sharepoint/libraries/introduction-to-sharepoint-formulas-and-functions) ## Related guides - [Use today's date in a SharePoint calculated column](/guides/sharepoint-calculated-column-today/) - [Show each person only their own items in a SharePoint list view](/guides/sharepoint-list-view-filter-current-user/) - [My SharePoint list view does not show all items](/guides/sharepoint-list-view-not-showing-all-items/) - [Split text into parts in Power Automate](/guides/power-automate-split-string/) Source: https://250highstreet.com/guides/sharepoint-list-view-filter-today-minus-days/