<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> This example database groups events in a Renaissance Faire by their time of day - Morning, Afternoon, and Evening. These three options are returned by the Time of Day formula property.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Renn Faire Events

// Compressed
if(hour(prop("Date")) >= 18, "🌔 Evening", if(hour(prop("Date")) >= 12, "🌤 Afternoon", "🌄 Morning"))

// Expanded
if(
    hour(
        prop("Date")
    ) >= 18,
    "🌔 Evening",
    if(
        hour(
            prop("Date")
        ) >= 12,
        "🌤 Afternoon",
        "🌄 Morning"
    )
)

© Thomas Frank