Formula Components

Formulas and Databases

Reference

Formula Examples

start

Learn how to use the start function in Notion formulas.

1

start(date)

`start()`

is useful for obtaining the start date from a Date property which contains a date range.When you pass a single date as the argument - i.e. from a Created Time/Last Edited Time property, or a timestamp -

`start()`

simply returns that date.1

// Assume a property "Date" exists, with

2

// a row value of June 23, 2022 β June 27, 2022

3

start(prop("Date")) // Outpuut: June 23, 2022

Itβs useful to note that date math functions like dateAdd and dateSubtract return a date object that does *not* contain a date range - even if their argument does include one.

When these functions are passed a date object that includes a range, they only use a start date.

For this reason, the following two formulas will return the exact same date:

1

// Assume a property "Date" exists, with

2

// a row value of June 23, 2022 β June 27, 2022

3

start(dateAdd(prop("Date"),30,"days")) // Output: July 23, 2022

4

β

5

end(dateAdd(prop("Date"),30,"days")) // Output: July 23, 2022

Therefore, you must use the end function *within* your date math function if you wish to operate on the end date in a date range:

1

// Assume a property "Date" exists, with

2

// a row value of June 23, 2022 β June 27, 2022

3

dateAdd(end(prop("Date")), 30, "days") // Output: July 27, 2022

The example database below counts the number of days in a date range.

start

College Info Geek on Notion

1

// Compressed

2

dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days")

3

β

4

// Expanded

5

dateBetween(

6

end(

7

prop("Date Range")

8

),

9

start(

10

prop("Date Range")

11

),

12

"days"

13

)

This example formula uses

`start()`

and end to pass beginning and ending arguments to the dateBetween function.By specifying "days" as the third argument, we get the number of days in the date range.

β My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

Last modified 21d ago

Copy link

On this page

Example Formula

Date Math within start() and end()

Example Database

View and Duplicate Database

"Days" Property Formula