Notion Templates
Notion Templates/
All Templates
All Templates/
🚌
Range Contain Today?
🚌

Range Contain Today?

Master Tag
Tips & Tricks
Created
Jul 24, 2020 06:15 PM
How It Works
https://www.redgregory.com/notion/2020/7/25/notion-formula-does-date-range-contain-today
Usage
formateDate
Or
And
Start
End
Web Tags
Formula
How To
Alternatives
Cover
Contain Today?
🔑
Duplicate and change date range below to test formula.
Contain Today?
Name
Date Range
Today?
Jul 1, 2020 → Aug 31, 2020
formula: formatDate(end(prop("Date Range")), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY") or formatDate(start(prop("Date Range")), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY") or dateBetween(now(), start(prop("Date Range")), "days") > 0 and dateBetween(now(), end(prop("Date Range")), "days") < 0