Kavisha is going deep into the formulas 2.0 rabbit hole. Here’s what she found for getting the last day of a month in a Notion database.

‍

lets(
 /* Gets the first date of the month */
 firstOfTheMonth, dateSubtract(today(), date(today()) - 1, "days"),
 
 oneMonthAdded, dateAdd(firstOfTheMonth, 1 , "month"),
 
 /* Gets the last date of the month */
 lastDateOfThisMonth, dateSubtract(oneMonthAdded, 1 , "day"),
 
 style("» Last day of the month: ", "gray") + style(lastDateOfThisMonth.format(), "b", "default")
)