Design

How To Find The Season From A Date In Notion

Sarah Brennan ·

notion-formula-seasons-1.png

🌤 Four Seasons Formula

Yes, Notion formulas can help automate elements of your database to streamline workflow, but it can also generate aesthetic stickers for a daily documents journal. This formula will return the season according to a date property. The guidelines I use to determine a season is from the astronomical rule. Of course, season start dates can change +- 1-2 days. The formula can be modified easily to accommodate for this change.

When Do The Seasons Start?

Generally, on the 21st of March (Spring), June (Summer), September (Fall), and December (Winter). The southern hemisphere is flipped.

To modify this formula, for example, if summer starts on the 20th of June this year and not the 21st, subtract 1 day from the statement associated with spring (1 season prior). If the season change lands on the 22nd, add 1 day.

Examples

Alter this number to change summer (Northern):

  • … if(toNumber(formatDate(prop("Date"), "DDD")) < 172, "🌷 Spring", …

Alter this number to Change Winter (Northern) or Summer (Southern):

  • … if(toNumber(formatDate(prop("Date"), "DDD")) > 354 and toNumber(formatDate(prop("Date"), "DDD")) < 367, "🧤 Winter", …

  • … if(toNumber(formatDate(prop("Date"), "DDD")) > 354 and toNumber(formatDate(prop("Date"), "DDD")) < 367, "🌞 Summer", …

Northern Hemisphere

notion-formula-seasons-2.jpg

if(toNumber(formatDate(prop("Date"), "DDD")) < 80, "🧤 Winter", if(toNumber(formatDate(prop("Date"), "DDD")) < 172, "🌷 Spring", if(toNumber(formatDate(prop("Date"), "DDD")) < 264, "🌞 Summer", if(toNumber(formatDate(prop("Date"), "DDD")) > 354 and toNumber(formatDate(prop("Date"), "DDD")) < 367, "🧤 Winter", "🍁 Fall"))))

Southern Hemisphere

notion-formula-seasons-3.jpg

if(toNumber(formatDate(prop("Date"), "DDD")) < 80, "🌞 Summer", if(toNumber(formatDate(prop("Date"), "DDD")) < 172, "🍁 Fall", if(toNumber(formatDate(prop("Date"), "DDD")) < 264, "🧤 Winter", if(toNumber(formatDate(prop("Date"), "DDD")) > 354 and toNumber(formatDate(prop("Date"), "DDD")) < 367, "🌞 Summer", "🌷 Spring"))))

View Example Inside Notion

Further Reading

Featured
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.

Push Overdue Tasks To Today In Notion

If a task is overdue, push the due date in Notion to today, and show the new due date in a calendar. If the task is not overdue or complete, show the original due date. We also explore how to see this new date formula in a calendar view. Calendars can only see one date at a time so it is important to join all dates you want to see into one Notion formula. Here is how it works.

Notion For Note-Taking: Where To Start

There are many reasons why Notion is a great note-taking app. For starters, it's extremely user-friendly and easy to use. The interface is clean and simple, making it quick and easy to find what you're looking for. There are also tons of features and customization options available, so you can tailor the app to your specific needs. Here is how you can get started.

Easy Hierarchical Note-Taking Method For Notion

Create a note-taking database in Notion that’s both easy to use and navigate. In this short tutorial I show you how to create a hierarchical structure for your notes using the relation property. For example, all parent notes have children notes that help describe the parent. This connection is made with a relation.