This function will add a specified number of months to a date.




ADDMNTHS((x), y)




x = a date. This is the date you wish to use to add months to, preferred format of YYYY,MM,DD such as 2019, 8, 22 for 22nd of August 2019. This can also be the name of a date attribute.


y = the number, either positive or negative, of months you wish to add to the date (x)


Type of Data Returned


A date will be returned.




ADDMNTHS((2019, 8, 22), 8) will return 22nd of April 2020.


ADDMNTHS((2019, 8, 22), 10) will return 22nd of June 2020.


ADDMNTHS((2019, 8, 22), -3) will return 22nd of May 2019.