MoveDate
Last updated
Last updated
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.
| Name | Type | Required | 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.