Savant

<code>date</code>: The starting date to which you want to add or subtract an interval.

<code>number</code>: The numeric value representing the amount you want to add or subtract.

DAY/MONTH/YEAR: Specify the time unit (day, month, or year) for the interval.

1. <code>date</code>: The starting date to which you want to add or subtract an interval.
2. <code>number</code>: The numeric value representing the amount you want to add or subtract.
3. DAY/MONTH/YEAR: Specify the time unit (day, month, or year) for the interval.

Adds a specified number of days, weeks, months, quarters, or years to a date

INTERVAL (Date)

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 `INTERVAL` function allows you to perform date arithmetic by adding or subtracting a specified number of days, months, or years to a given date. This is useful for calculating future dates, project timelines, or aging calculations.
Syntax	`date` + INTERVAL `number` DAY/MONTH/YEAR
Output	date

Project	Start Date	INTERVAL
Project A	2023-09-10	September 17, 2023
Project B	2023-08-25	September 1, 2023
Project C	2023-09-01	September 8, 2023

Project	Start Date	INTERVAL
Project A	2023-09-10	September 10, 2023
Project B	2023-08-25	August 25, 2023
Project C	2023-09-01	September 1, 2023

Project	Start Date	INTERVAL
Project A	2023-09-10	August 10, 2023
Project B	2023-08-25	July 25, 2023
Project C	2023-09-01	August 1, 2023

Variables

Example 1

Example 2

Example 3