4 Essential Notion Date Formulas

From the Red Gregory content archive

In personal news, this week has been a whirlwind after getting a new puppy, and with that, a brand new sleep schedule. Luckily, I was able to get some content out this week in addition to a new video on mental clarity in Notion coming soon. 😜

Meet Billie

She’s a rescue mutt from my local shelter who’s likely a yellow lab mix by the look of her. She’s been doing a really good job at house training, and unlike the picture suggests, she is NOT a fan of sleeping 😴, but as she gets more comfortable she is taking more naps. My content in the next few weeks will most certainly be taken over by pictures of her.

---

1. Formatting Dates

Database properties you’ll need:

• Date titled “Date”

• Formula

formatDate(prop("Date"), "YYYY-MM-DD")

2. Match Today/Tomorrow

Database properties you’ll need:

• Date titled “Date”

• Formula

Today: formatDate(prop("Date"), "MM DD YYYY") == formatDate(now(), "MM DD YYYY")

Tomorrow: format(dateSubtract(prop("Date"), 1, "days")) == formatDate(now(), "MMMM D, YYYY")

3. Find Time Elapsed

Database properties you’ll need:

• Date titled “Date” that has a start and end date (date range). Also, a time included for the start and end dates.

• Formula

Hours (decimal): round(100 * (dateBetween(end(prop("Date")), start(prop("Date")), "minutes") / 60)) / 100

4. Convert Time To 12am

Database properties you’ll need:

• Date titled “Date” that includes a time.

• Formula

dateSubtract(dateSubtract(prop("Date"), hour(prop("Date")), "hours"), minute(prop("Date")), "minutes")

More formulas

---