Current Day, Week, Month, Quarter

Current Day, Week, Month, Quarter

Master Tag

Tips & Tricks

Created

Mar 23, 2021 05:11 PM

How It Works

https://www.redgregory.com/notion/2021/3/23/notion-tip-how-to-show-entries-in-current-week-monday-sunday

Usage

formateDate

Web Tags

Database

Formula

Alternatives

Daily Document Dashboard

Cover

Week Of Month (6).png

notion image

Week, Month, Quarter

notion image

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")