MoveDate

The MoveDate()function shifts a date by a given amount of a date unit.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

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

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

MoveDate(date, number, unit)

MoveDate('2016-05-02T05:37:44', -3, year)=>Result: Thursday, May 2, 2013 5:37:44 AM

MoveDate(UnknownDate, UnknownNumber, Unknownunit)=>Result: (unknowndate)

Name Type Required Description

Name	Type	Description
`date`	date time	a date
`number`	numeric	the number or amount that a date the value is moved.
`unit`	Keyword	the [date unit] that is moved in `date.` Possible values: year, month, week, day, hour, minute or second.

date

date time

a date

number

numeric

the number or amount that a date the value is moved.

unit

Keyword

the [date unit] that is moved in date. Possible values: year, month, week, day, hour, minute or second.

Last updated 11 days ago