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 indate
.unit
the [date unit][1] that is shifted indate
.
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' */