Red Gregory

View Original

4 Notion Formulas: Match Dates And Titles

Date Format Reference

See this content in the original post

Find more ways to format dates in Notion

See this content in the original post

Formulas are made for the example above. Formatting styles should be changed according to the date style of your text. Refer to reference table for more date formatting options.

1. Match Current Year To Date

contains(prop("Name"), format(year(now())))

Date Property Equivalent

year(now()) == year(prop("Date"))

2. Date Matches Today

formatDate(now(), "MMMM Do YYYY") == prop("Name")

Date Property Equivalent

formatDate(now(), "LL") == formatDate(prop(“Date”), "LL")

3. Date Matches Tomorrow

formatDate(dateAdd(now(), 1, "days"), "MMMM Do YYYY") == prop("Name")

Date Property Equivalent

formatDate(dateAdd(now(), 1, "days"), "LL") == prop(“Date”)

4. Date Matches This Month and Year

contains(prop("Name"), formatDate(now(), "MMMM")) and contains(prop("Name"), formatDate(now(), "YYYY"))

Date Property Equivalent

formatDate(now(), "M Y")) == formatDate(prop(“Date”), "M Y"))

Further Reading

See this gallery in the original post