addMonths()

Returns a TIMESTAMP resultant of adding n months to timestamp t.

Use this function instead of simply adding n * {MONTH}, since {MONTH}is a macro equivalent to 30 * {DAY}. Negative values for n are used in order to subtract instead of adding.

Syntax

addMonths(timestamp, months, timeZone time_zone) #Output: Number

Examples

Parser expression	Description
addMonths(t, 3, LOCAL) timestamp t has the value: March 25th, 2011 23:15	This function returns a timestamp as a NUMBER with the value: June 25th, 2011 23:15

Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

numberOfDays

NUMBER

The number defined here will be the offset in days.

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro {DAY} to add full days to the timestamp. Learn more about time macros.

timeZone

TIMEZONE

The time zone used for the calculation.

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia.

Output

The function returns a TIMESTAMP.

In this function we are not taking into consideration the fact that some months have more or less than 30 days.

Content

Space Tools

Parameters used in this function