<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> Notion’s dateBetween function subtracts the second argument from the first, and returns a number depending on the specified unit of time (e.g. “hours” or “seconds”).

If the second argument is a later date than the first argument’s date, dateBetween() will return a negative number. The formula in the table below uses the abs() function to ensure that the output is always positive.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Date Between - Absolute

abs(dateBetween(prop("Date 1"), prop("Date 2"), "seconds"))

© Thomas Frank