AddMonths

Adds a specified number of months to a point in time.

Syntax

• AddMonths(t, n)

  • t is a datetime structure or a timestamp

  • n is an integer

Description

AddMonths(t, n) returns the point in time obtained by adding n whole months to t. If t is a DateTime structure or a timestamp, so is the result.

Examples

AddMonths(date(2020, 05, 20), 5)

date.year: 2020
date.month: October
date.day: 20
time.hour: 0
time.minute: 0
time.second: 0
time.millisecond: 0