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 time | a date | |
| numeric | | the number or amount that a date the value is moved. |
| Keyword | | the [date unit] that is moved in |