Date Add

Introduction Adds a fixed time interval to the specified date. Parameter Description date: is the specified date. This function will add a certain time interval to this date. count: is the time interval, supports input of numbers with positive and negative signs. If it is a positive number, it means adding a few days (custom time unit), see example one; if it is a negative number, it means reducing a few days, see example two; units: is the time unit, i.e., the unit for adding the time interval. For example, calculating by "days" can also be converted to calculating by "years". Time units include the following symbols, both formats can be used: "Unit Description" → "Abbreviation" Milliseconds: "milliseconds" → "ms" Seconds: "seconds" → "s" Minutes: "minutes" → "m" Hours: "hours" → "h" Days: "days" → "d" Weeks: "weeks" → "w" Months: "months" → "M" Quarters: "quarters" → "Q" Years: "years" → "y" Click the link below to view all time units.

Input formula

Select a field or function

Number

Sum

Average

Max

Min

Round

Round Up

Round Down

Ceiling

Floor

Even

Odd

Int

Abs

Sqrt

Mod

Power

Exp

Log

Value

Text

Concatenate

Find

Mid

Replace

Substitute

Len

Left

Right

Lower

Upper

Rept

Trim

Encode URL Component

Logic

Switch

True

False

And

Xor

Blank

Error

Is Error

Not

Date

Today

Now

To Now

From Now

Date Add

Datetime Diff

Workday

Workday Diff

Is After

Is Before

Is Same

Datetime Format

Datetime Parse

Datestr

Timestr

Year

Month

Weekday

Weeknum

Day

Hour

Minute

Second

Set Locale

Set Timezone

Created Time

Last Modified Time

Array

Array Compact

Array Unique

Array Join

Array Flatten

Count

CountA

CountIf

CountAll

Object

Record ID

DATE ADD

Usage

DATEADD(date, count, units)

Example

DATEADD({date of begin}, 10, "days")

Template

Help

Pricing

Recommend Reading

Date Add

DATE ADD