<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 demonstrates how to output a date object set to January 1, 12:00 AM in the current year, in your current time zone.

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

</aside>

Jan 1

// Compressed
dateSubtract(dateSubtract(dateSubtract(dateSubtract(now(), minute(now()), "minutes"), hour(now()), "hours"), date(now()) - 1, "days"), month(now()), "months")

// Expanded
dateSubtract(
    dateSubtract(
        dateSubtract(
            dateSubtract(
                now(), 
                minute(
                    now()
                ), 
                "minutes"
            ), 
            hour(
                now()
            ), 
            "hours"
        ), 
        date(
            now()
        ) - 1, 
        "days"
    ), 
    month(
        now()
    ), 
    "months"
)

© Thomas Frank