Thread by @NoCodeLuc

Want to create your next build in Notion with date formulas?

With Notion you can make databases while only needing a little knowledge of rearranging and if-statements. These 20 date formulas will help you with your next build.

1. DATE IS TOMORROW
formatDate(dateAdd(now(), 1, "days"), "L") == formatDate(prop("Date"), "L")

2. DATE IS TODAY
formatDate(prop("Date"), "L") == formatDate(now(), "L")

3. DATE IS BEFORE OR ON TODAY
now() > prop("Date")

4. DATE IS BEFORE TODAY
now() > prop("Date") and formatDate(prop("Date"), "L") != formatDate(now(), "L")

5. DATE IS AFTER OR ON TODAY
formatDate(now(), "L") == formatDate(prop("Date"), "L") or now() < prop("Date")

6. DATE IS AFTER TODAY
now() < prop("Date")

7. DATE LANDS IN THIS WEEK (M-SU)
formatDate(prop("Date"), "W") == formatDate(now(), "W")

8. DATE LANDS IN THIS WEEK (SU-SA)
formatDate(prop("Date"), "w") == formatDate(now(), "w")

9. TODAY FALLS WITHIN DATE-RANGE
now() > start(prop("Date-Range")) and now() < end(prop("Date-Range")) or or(formatDate(now(), "L") == formatDate(start(prop("Date-Range")), "L"), formatDate(now(), "L") == formatDate(end(prop("Date-Range")), "L"))

10. FROM DATE, FIND MONTH AND RETURN FIRST DAY OF MONTH
dateSubtract(prop("Date"), date(prop("Date")) - 1, "days")

11. FROM DATE, FIND MONTH AND RETURN LAST DAY OF MONTH
dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days")

12. DATE LANDS IN LEAP YEAR
if( year( prop("Date") ) % 4 == 0, if( year( prop("Date") ) % 100 == 0, if( year( prop("Date") ) % 400 == 0, true, false ), true ), false )

13. WEEK NUMBER OF MONTH DATE LANDS IN (M-SU)
ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days")) - 1) / 7)

14. WEEK NUMBER OF MONTH DATE LANDS IN (SU-SA)
ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"))) / 7)

15. WEEKLY PROGRESS INDICATOR FROM DATE (SU-SA)
slice("◻️◻️◻️◻️◻️◻️◻️", 0, day(prop("Date")) * 2) + "🔲" + slice("◼️◼️◼️◼️◼️◼️◼️", 1, 14 - day(prop("Date")) * 2)

16. WEEKLY PROGRESS INDICATOR FROM DATE (M-SU)
if(day(prop("Date")) != 0, slice("◻️◻️◻️◻️◻️◻️◻️", 0, (day(prop("Date")) - 1) * 2) + "🔲" + slice("◼️◼️◼️◼️◼️◼️◼️", 1, 14 - (day(prop("Date")) - 1) * 2), "◻️◻️◻️◻️◻️◻️🔲")

17. TOTAL DAYS IN DATE'S MONTH
date(dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days"))

18. FIND EXACT HOURS BETWEEN DATE-RANGE
round(10 * dateBetween(end(prop("Date-Range")), start(prop("Date-Range")), "minutes") / 60) / 10

19. FIND HOURS AND MINUTES BETWEEN DATE-RANGE
format(dateBetween(end(prop("Date-Range")), start(prop("Date-Range")), "hours")) + " hr " + format(dateBetween(end(prop("Date-Range")), start(prop("Date-Range")), "minutes") % 60) + " min"

20. FIND WHAT QUARTER DATE LANDS IN
formatDate(prop("Date"), "Q")

For a complete list checkout RedGregory's Notion blog: redgregory.com/notion/30-date…

Checkout @RedGregory1