MoveDate
Last updated
Last updated
The MoveDate()
function shifts a date by a given amount of a date unit.
This function is 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.
Although MoveDate() IS SQL Compatible - meaning it will be used on the database to return a smaller resultset, it may be slow in execution on the database, depending on the situation (number of records, distribution over data-pages, the filter in total with maybe other fields) where SQL may not be able to optimize the execution plan...
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.