dateBetween Guide

dateBetween Guide

dateBetween Guide

Master Tag

Tips & Tricks

Created

Jul 30, 2022 12:07 PM

How It Works

https://www.redgregory.com/notion/2022/7/30/ultimate-guide-to-notions-datebetween-function

Usage

dateBetween

Format

minute

Hour

Start

End

Mod

Web Tags

Function

Formula

How To

Alternatives

Cover

💡

This is a series of examples to better understand Notion’s dateBetween function.

dateBetween Example 2 Dates

Name

Start

End

Years

Quarters

Months

Weeks

Exact Weeks

Days

Weeks + Days

Jul 11, 2022

Jul 22, 2022

NaN

undefined wk(s), NaN dy(s)

Jul 20, 2022

Nov 16, 2022

NaN

undefined wk(s), NaN dy(s)

dateBetween Example Date Range

Name

Date Range

Years

Quarters

Months

Weeks

Exact Weeks

Days

Weeks + Days

Jul 11, 2022 → Jul 22, 2022

NaN

undefined wk(s), NaN dy(s)

Jul 20, 2022 → Nov 16, 2022

NaN

undefined wk(s), NaN dy(s)

dateBetween Example 2 Dates (w/ Time)

Name

Start

End

Years

Quarters

Months

Weeks

Days

Hours

Exact Hours

Minutes

Days + Hours + Minutes

Jul 11, 2022 15:00

Jul 12, 2022 14:10

NaN

undefined dy(s), NaN hr(s), NaN min(s)

Jul 20, 2022 04:00

Jul 19, 2022 16:45

NaN

undefined dy(s), NaN hr(s), NaN min(s)

dateBetween Example Date and Now

Name

Deadline

Years

Quarters

Months

Weeks

Days

Hours

Exact Hours

Minutes

Days + Hours + Minutes

Aug 1, 2022

NaN

undefined dy(s), NaN hr(s), NaN min(s)

Jul 28, 2022

NaN

undefined dy(s), NaN hr(s), NaN min(s)

dateBetween Example Date Range (w/ Time)

Name

Date Range

Years

Quarters

Months

Weeks

Days

Hours

Exact Hours

Minutes

Days + Hours + Minutes

‣

NaN

undefined dy(s) - NaN hr(s), NaN min(s)

‣

NaN

undefined dy(s) - NaN hr(s), NaN min(s)