/
DATE_ADD()

DATE_ADD()

Owned by Pedro Jose Sanchez Luling
Last updated: Mar 05, 2025
2 min read
DATE_ADD(date, value, [unit])

API Version

2.7.9 and higher

Adds a value to a date and returns the final date.

If the DATE provided does not include a time part (e.g. "2019-19-21"), the value returned will have the same format unless the calculation modifies the time part (for example when adding seconds, minutes or hours), in which case a full date time string will be returned.

Input parameters

Parameters

Type

Default

Required

Description

Default

Parameters

Type

Default

Required

Description

Default

date

Any

 

Yes

Base date

Formula TODAY() is also supported

 

value

Number/String

 

Yes

Value to increment the date. Negative values are allowed. Two types of value are accepted

  • Numeric value: Number of days, hours, minutes... to add to the base date. Decimal values are allowed. The units depend on the value of parameter UNIT

  • a string specifying a valid time (e.g. "12:00:34"). A negative value is also supported (e.g. "-5:21:00")

 

unit

String

"D"

No

Units in which VALUE is expressed. Accepted values are:

  • "s" : seconds

  • "m": minutes

  • "h" : hours

  • "D": days

  • "M": months

  • "Y": years

If no unit is specified, then "D" is the default value

If VALUE is expressed as a time string, then this parameter is ignored

 

 

Return value

Type

Description

Type

Description

String

Returns the final date after adding the requested value.

The date returned has the format "YYYY-MM-DD hh:mm:ss" or "YYYY-MM-DD" depending on the initial format of DATE.

Execution

Always. Calculated on-the-fly whenever an ITEM of a FORM is changed (by means of form_set_answer(), or when the FORM is opened

Examples

Formula

Description

Formula

Description

DATE_ADD("2019-05-12 12:21:05", 5)

No UNIT specified, so "D" is assumed. The final result would be "2019-05-17 12:21:05"

DATE_ADD("2019-05-12 12:21:05", "-01:05:00")

Value expressed as a time string. The final result would be "2019-05-12 11:16:05"

DATE_ADD($1, 5, "M")

Adds 5 months to the date in ITEM $1

DATE_ADD("2019-05-12", 5, "D")

Base date does not have time part.. 

The final result would be "2019-05-17" because the calculation does not generate a time part

DATE_ADD("2019-05-12", 5, "s")

Base date does not have time part.. 

The final result would be "2019-05-17 00:00:05" because the calculation generates a time part

DATE_ADD("2019-05-12", 1.5, "D")

Add a decimal number of days. The result would be "2019-05-13 12:00:00"

 

 

Related content