larger

The larger (>) operator returns true if its left operand is greater than its right operand. It accepts numeric, date, and Boolean operands.

number > number
Boolean > Boolean
date > date

larger(number, number)
larger(Boolean, Boolean)
larger(date, date)

You can also use the function version, larger().

Example Formulas

2 > 1 // Output: true

42 > 50 // Output: false

// Boolean values equate to 1 (true) and 0 (false).
true > false // Output: true

true > true // Output: false

// For dates, "less than" equates to "before".
now() > dateSubtract(now(), 1, "days") // Output: true

Good to know: When comparing dates, “larger” = “later”.

Good to know: The larger (>) operator cannot be chained in a Notion formula. A formula like 3 > 2 > 1 won’t work. Use the and operator to get around this – e.g. 3 > 2 and 2 > 1.

Example Database

This example database records the power levels of two fighters at different stages. The Stronger formula outputs a sentence stating who the stronger fighter is at that time.

View and Duplicate Database

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.

A new tool that blends your everyday work apps into one. It’s the all-in-one workspace for you and your team

thomasfrank.notion.site

“Stronger” Property Formula

((prop("Goku") > prop("Vegeta")) ? "Goku is stronger" : "Vegeta is stronger") + " during " + prop("Saga") + "."

This formula uses the conditional operators ? and : to form an if-then statement. The output is then combined with strings and the output of the Saga property via the add (+) operator (which can concatenate strings).

Other formula components used in this example:

if – Thomas Frank

thomasjfrank.com

add – Thomas Frank

thomasjfrank.com