Function reference
Obtains the date that occurs a specified number of months after or before another date.
RelativeMonth( date, n )
| Argument | Description |
| DateTime | A datetime |
| n | An integer indicating the number of months |
Data type: Date
Returns the date that occurs n months after date if n is greater than 0. Returns the date that occurs n month before date if n is less than 0.
Example
This expression returns 2013-04-27 00:00:00
RelativeMonth(DateTime(‘2013-01-27’,Time(‘00:00:00’)) , 3)
Last modified:
29 May 2021