Beli Löw
How it Works
The DateBetween formula is one of Notion's most useful date functions for calculating the time difference between two dates. Here's how it works:
Syntax
dateBetween(date1, date2, unit)Parameters
- Date1: The first date (usually the later/end date)
- Date2: The second date (usually the earlier/start date)
- Unit: The unit of measurement - can be "years", "months", "weeks", "days", "hours", "minutes", or "seconds"
How it Calculates
The formula calculates the difference from date2 to date1. So if you want to find someone's age, you'd use:
This calculates from their birth date to today, giving you their age in years.
To display age in your contact database, you can choose a simple formula which shows. Age: 17 or you can select the version with icon, date, and age 🎂 22.08.2005 (17)
dateBetween(now(), prop("Date of Birth"), "years")Step-by-step guide
- Create a
Datefield with the label "Date of birth" - Create a
Formulafield - Copy the formula code from below into the formula field
Version with age only Age: 17
if(not empty(prop("Date of Birth")), "Age: " + format(dateBetween(now(), prop("Geburtsdatum"), "years")), "")Version with icon, date and age 🎂 22.08.2005 (17)
if(not empty(prop("Date of Birth")), "🎂 " + formatDate(prop("Date of Birth"), "DD.MM.YYYY") + " (" + format(dateBetween(now(), prop("Geburtsdatum"), "years")) + ")", "")This is how it can look when you display it as a gallery or table.
How You Can Implement them on your Business Workspace
- Track days left to finish your taks.
- Keep track of projects deadlines.
FAQ
Beli Löw
Founder, Senior Notion Consultant
Beli is an IT project manager, tool enthusiast, entrepreneur and has organized his whole life with Notion. His news sources are release notes from tools. There is (almost) no feature or shortcut that he does not know.
Level Up Your Business Workspace: Get Monthly Notion Pro Tips
Keep Reading…
