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' */

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company