This question comes from a reader of the Notion course. It has been organized and shared here. If you encounter similar issues while using Notion, feel free to leave a comment.
Reader's Question
I recently created an expense tracker database, but ran into a problem. I want to see my spending summary for "last month," but the filter only offers options "relative to today." For example, since today is November 2nd, the filter can only show records starting from October 2nd. This means I have to manually adjust the start date for "last month's expenses" every month. Is there a method I'm missing?
If you're also using Notion for expense tracking, check out this tutorial on auto-updating account balances in a database accounting setup.
My Answer
The simplest approach is to group by the "Date" property. In the grouping options under "By date," select "Month." This lets you quickly filter out records for each month.
Alternatively, you can add a Formula property that checks whether a page's date falls within last month's range. If it does, the formula returns a checkmark. Then you can filter by this Formula property to show only the checked pages.
today().dateAdd(-1,"month").formatDate("YYYYMM")==日期.formatDate("YYYYMM")The result is shown in the image below.
📘 FLO.W — Notion Personal Management System
FLO.W is a Notion-based personal management template that integrates tasks, notes, projects, habits, and more, complete with comprehensive tutorials.
