.png?table=block&id=5a711431-1fb4-4aea-bcbf-02848bba78bb&cache=v2)
Donate
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.
Â
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
Title Formula To Find Tomorrow’s Date
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"))