Wszystkie wskazówki

Notion Formula 2.0: Last Day of the Month

The last day of the month is a common software issue and different tools/languages require different implementation.

But usually, the algorithm is the same: First day of next mont - 1 day

Last Day of the Month Notion Formula:

For Notion users, Kavisha shared a pretty nice implementation:

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")
)
Zrzut ekranu Notion Formula 2.0 pokazujący, jak obliczyć ostatni dzień miesiąca
Zrzut ekranu Notion Formula 2.0 pokazujący, jak obliczyć ostatni dzień miesiąca
Zrzut ekranu Notion Formula 2.0 pokazujący, jak obliczyć ostatni dzień miesiąca

Najlepsze szablony

The Money OS Notion template displayed on two MacBook laptops against a dark, professional backdrop. Left screen shows sophisticated financial analytics with multiple line graphs tracking income and expenses over time. Right screen demonstrates the dark-mode interface with navigation icons and current month financial tracking. 'Made for Notion' badge in top-left corner emphasizes native integration. Stylish product visualization highlighting The Money OS's comprehensive financial management and analysis capabilities in a modern, premium presentation.
Advanced KPIs Tracker Notion template: Dark-mode interface with KPI dashboard, progress bars, and performance chart on laptop screen. Made for Notion."
Simple KPIs Tracker Notion template in dark mode on laptop screen. Dashboard displays three KPI cards with progress bars, targets, and current values. Clean interface for efficient performance tracking, ideal for startups and small businesses using Notion.

Więcej

Najlepsze szablony

The Money OS Notion template displayed on two MacBook laptops against a dark, professional backdrop. Left screen shows sophisticated financial analytics with multiple line graphs tracking income and expenses over time. Right screen demonstrates the dark-mode interface with navigation icons and current month financial tracking. 'Made for Notion' badge in top-left corner emphasizes native integration. Stylish product visualization highlighting The Money OS's comprehensive financial management and analysis capabilities in a modern, premium presentation.
Advanced KPIs Tracker Notion template: Dark-mode interface with KPI dashboard, progress bars, and performance chart on laptop screen. Made for Notion."
Simple KPIs Tracker Notion template in dark mode on laptop screen. Dashboard displays three KPI cards with progress bars, targets, and current values. Clean interface for efficient performance tracking, ideal for startups and small businesses using Notion.

Więcej

Najlepsze szablony

The Money OS Notion template displayed on two MacBook laptops against a dark, professional backdrop. Left screen shows sophisticated financial analytics with multiple line graphs tracking income and expenses over time. Right screen demonstrates the dark-mode interface with navigation icons and current month financial tracking. 'Made for Notion' badge in top-left corner emphasizes native integration. Stylish product visualization highlighting The Money OS's comprehensive financial management and analysis capabilities in a modern, premium presentation.
Advanced KPIs Tracker Notion template: Dark-mode interface with KPI dashboard, progress bars, and performance chart on laptop screen. Made for Notion."
Simple KPIs Tracker Notion template in dark mode on laptop screen. Dashboard displays three KPI cards with progress bars, targets, and current values. Clean interface for efficient performance tracking, ideal for startups and small businesses using Notion.

Więcej

Podobne wskazówki
Comment icon representing the ability to add comments in Notion, used as a thumbnail for a guide on adding comments in Notion.
Add Comment in Notion

Comment icon representing the ability to add comments in Notion, used as a thumbnail for a guide on adding comments in Notion.
Add Comment in Notion

Comment icon representing the ability to add comments in Notion, used as a thumbnail for a guide on adding comments in Notion.
Add Comment in Notion

White logo of notion on gray background
New Notion iPhone Shortcuts

White logo of notion on gray background
New Notion iPhone Shortcuts

White logo of notion on gray background
New Notion iPhone Shortcuts

Black and white Notion logo suggesting that content of the Tip is about Notion
Lock Your Notion Pages

Black and white Notion logo suggesting that content of the Tip is about Notion
Lock Your Notion Pages

Black and white Notion logo suggesting that content of the Tip is about Notion
Lock Your Notion Pages

Notion app icon showing a white 3D cube with the letter 'N' on dark background - simple visual guide for Notion dark mode shortcuts tutorial
Quickly Switch Light/Dark Mode In Notion

Notion app icon showing a white 3D cube with the letter 'N' on dark background - simple visual guide for Notion dark mode shortcuts tutorial
Quickly Switch Light/Dark Mode In Notion

Notion app icon showing a white 3D cube with the letter 'N' on dark background - simple visual guide for Notion dark mode shortcuts tutorial
Quickly Switch Light/Dark Mode In Notion

Nigdy nie przegap nowych wskazówek

Bądź na bieżąco z wszystkimi wiadomościami co tydzień w newsletterze

Nigdy nie przegap nowych wskazówek

Bądź na bieżąco z wszystkimi wiadomościami co tydzień w newsletterze

Nigdy nie przegap nowych wskazówek

Bądź na bieżąco z wszystkimi wiadomościami co tydzień w newsletterze

Twarz Lukasa Ostrowskiego, przedsiębiorcy zajmującego się automatyzacją
Łukasz Ostrowski

Przedsiębiorca automatyzacji

Twarz Lukasa Ostrowskiego, przedsiębiorcy zajmującego się automatyzacją
Łukasz Ostrowski

Przedsiębiorca automatyzacji

Twarz Lukasa Ostrowskiego, przedsiębiorcy zajmującego się automatyzacją
Łukasz Ostrowski

Przedsiębiorca automatyzacji