Savant

<code>End_date</code>: The ending date for the calculation.

<code>Start_date</code>: The starting date for the calculation.

"day"/"week"/"month"/"quarter"/"year": Specify the time unit (day, week, month, quarter, or year) for the calculation.

1. <code>End_date</code>: The ending date for the calculation.
2. <code>Start_date</code>: The starting date for the calculation.
3. "day"/"week"/"month"/"quarter"/"year": Specify the time unit (day, week, month, quarter, or year) for the calculation.

NOTE: Please note that the <code>End_date</code> and <code>Start_date</code> should both be in the same data type (e.g., date or datetime).

DATE_DIFF(`End Date`, `Start Date`, "DAY")

DATE_DIFF(`End Date`, `Start Date`,"WEEK")

DATE_DIFF(`End Date`, `Start Date`,"MONTH")

Calculates the difference in days, weeks, months, quarters, or years between two dates

DATE_DIFF

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	The `DATE_DIFF()` function computes the time difference in days, weeks, months, quarters, or years between two provided dates (End_date and Start_date). This is useful for tracking durations, aging calculations, or date-based analytics.
Syntax	DATE_DIFF(`End_date`, `Start_date`, “day”/”week”/”month”/”quarter”/”year”)
Output	integer

Project	Start Date	End Date	DATE_DIFF
Project A	2023-09-05	2023-09-15	10
Project B	2023-08-25	2023-09-10	16
Project C	2023-09-01	2023-09-30	29

Project	Start Date	End Date	DATE_DIFF
Project A	2023-09-05	2023-09-15	1
Project B	2023-08-25	2023-09-10	2
Project C	2023-09-01	2023-09-30	4

Project	Start Date	End Date	DATE_DIFF
Project A	2023-09-05	2023-09-15	0
Project B	2023-08-25	2023-09-10	1
Project C	2023-09-01	2023-09-30	0

Variables

Example 1

Example 2

Example 3