Savant

<code>date</code>: The initial date or datetime to which you want to add an offset.

<code>offset</code>: The numeric value representing the quantity of time you want to add.

"second/minute/hour/day/month/year": The unit of time (e.g., seconds, minutes, hours, days, months, years) you want to add to the initial date or datetime.

1. <code>date</code>: The initial date or datetime to which you want to add an offset.
2. <code>offset</code>: The numeric value representing the quantity of time you want to add.
3. "second/minute/hour/day/month/year": The unit of time (e.g., seconds, minutes, hours, days, months, years) you want to add to the initial date or datetime.

DATE_ADD(`Start Date and Time`, -1, 'day')

Adds a specified offset of time (e.g., seconds, minutes, hours) to a given date or datetime

DATE_ADD

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_ADD()` function enables you to add a specific time offset, such as seconds, minutes, hours, days, months, or years, to a given date or datetime. This function is indispensable for tasks like scheduling events, calculating future dates, or managing time-based data transformations.
Syntax	DATE_ADD(`date`, `offset`, "second/minute/hour/day/month/year")
Output	date

Task	Start Date and Time	DATE_ADD(`Start Date`, 2, 'hour')
Task A	2023-09-10 10:30:00.000	2023-09-10 12:30:00.000
Task B	2023-08-25 04:00:00.000	2023-08-25 06:00:00.000
Task C	2023-09-01 17:15:00.000	2023-09-01 19:15:00.000

Task	Start Date and Time	DATE_ADD(`Start Date and Time`, -1, 'day')
Task A	2023-09-10 10:30:00.000	2023-09-09 10:30:00.000
Task B	2023-08-25 04:00:00.000	2023-08-24 04:00:00.000
Task C	2023-09-01 17:15:00.000	2023-08-31 17:15:00.000

Variables

Example 1

Example 2