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")