Database

How To Show Current Week, Month And Quarter In Notion

Sarah Brennan ·

notion-current-week-month-formula.png

📅 Filter Dates 101

There are several ways to filter and sort Notion databases by dates. The following formulas and filters can help a user create unique database views for entries. For example, filtering dates by the current week , by the current month, and by the current quarter. Formulas like this are necessary when filters alone don’t work. Here is how it works.

2022-2023 Calendars

A bundle of calendar images for Notion galleries that span from Sep 2022 to Dec 2023 + more!

Claim Your Copy

How The Formulas Work

Each property determines if a single date falls within the current day, week (Mon-Sun), week (Sun-Sat), month, and quarter.

Click to expand

Today Formula

formatDate(prop("Date"), "MMM D, YYYY") == formatDate(now(), "MMM D, YYYY")

Current Week (M-Su)

formatDate(prop("Date"), "W") == formatDate(now(), "W")

Current Week (Su-Sa)

formatDate(prop("Date"), "w") == formatDate(now(), "w")

Current Month

formatDate(prop("Date"), "M") == formatDate(now(), "M")

Current Quarter

formatDate(prop("Date"), "Q") == formatDate(now(), "Q")

 

Filter Database Views

Filter a database view to show only the week, month or quarter with the formulas above and a filter.

Firstly, add a new database view.

notion-current-week-month-formula-3.png

Next, create a filter that shows the chosen formula property as true.

Screen Shot 2021-03-24 at 8.51.51 AM.png

Lastly, sort the view as Date Ascending to arrange the dates in chronological order.

notion-current-week-month-formula-5.png

Here’s A Template Where I Use This

 

Further Reading

Featured
Free Notion Template: Airline Ticket Organizer for Travel

For those looking for an easy way to manage their travel information, this Notion template for airline tickets can provide a great solution. This template is designed to help users keep track of airline tickets and associated information. It includes sections for collecting and organizing information like flight number, departure and arrival times, airline, layovers, and more.

Free Notion Template: Address List with Map Generator

This address list Notion template is a great tool for organizing places you’re going, places you’ve been, or places to catalog. In this post, we'll look at how the address list can be used to keep track of address information for individuals, businesses, or other places. The template includes properties that describe an address’s name of place, building status, and country, in addition to generating links to Google and Apple maps.

11 Ways to Generate Clickable Links with Notion Formulas

Notion formulas can now be used to create clickable links that make constructing and navigating URL links a breeze. Creating clickable links in Notion formulas only requires inputting the correct code that results in a url syntax (https://www.website.com/…). Below are instructions on how to generate clickable links in Notion formulas for maps, social media searches, Twitter profiles, Wikipedia, Goodreads, and Amazon.

Populate A Weekly Spread From a Notion Calendar

This is a weekly spread between Monday and Sunday that will auto-populate from a Notion calendar. All days are spread into two rows of four columns. For those who like the presentation of a non-database weekly spread but also like the convenience of a database manager, this is the best of both worlds, and it takes a few minutes to setup. There is also the option to duplicate the Notion template below the tutorial.