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.

This expression returns 2013-04-27 00:00:00
RelativeMonth(DateTime(‘2013-01-27’,Time(‘00:00:00’)) , 3)

Last modified: 29 May 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment