MoveDate

The MoveDate() function shifts a date.

Syntax

MoveDate(date, number, unit)

Returns

A new date where a number of units is added/subtracted to/from a date.

Parameters

• date a date.
• number the number of units that is shifted in date.
• unit the [date unit][1] that is shifted in date.

Examples

MoveDate('2014-08-21', 5, Year)
/* Returns '2019-08-21' */

MoveDate('2014-08-21', 15, Day)
/* Returns '2014-09-05' */

MoveDate('2014-08-21', -365, Day)
/* Returns '2013-08-21' */