Donate

<aside> 🚩 The formulas below show you how to match titles and text properties to dates like finding a current year, current date, tomorrow’s date, and more. Included are formulas that can return the equivalent solution for a date property.

</aside>

Dates

1. Match Current Year To Date

Title Formula To Find Current Year

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

Date Property Equivalent

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

2. Date Matches Today

Title Formula To Find Current Date

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

Date Property Equivalent

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

3. Date Matches Tomorrow

Title Formula To Find Tomorrow’s Date

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