AddMth function

Official Content
This documentation is valid for:

Adds a specific number of months to a given date.


AddMth(date-expression | datetime-expression , numeric-expression)


date-expression | datetime-expression
   Given date or datetime.

   The number of months added to the date-expression | datetime-expression.

Type Returned:
Date | Datetime


Objects: Procedure, Transaction, Web Panel Panel, Data Provider


Returns a value that results from adding numeric-expression months to date-expression or datetime-expression. When the type assigned is date, it returns a date value, and when the type assigned is datetime it returns a datetime.

If the numeric expression is negative, the months are subtracted from the given date.


Date1 = ADDMTH(Today(),2) // Today() = 31/03/2008
// Result: Date1 = 31/05/2008 if Date1 is a date type attribute

Date2 = ADDMTH(Today(),1) // Today() = 31/03/2008
// Result: Date2 = 30/04/2008 00:00:00 if Date2 is a datetime type attribute

Date3 = ADDMTH(Date2,1) // Date2 = 30/04/2008
// Result: Date3 = 30/05/2008 if Date3 is a date type attribute

Date4 = ADDMTH(Today(),-2) // Today() = 21/09/2008
// Result: Date4 = 21/07/2008 if Date2 is a date type attribute

Date5 = ADDMTH(Now(),1) // Now() = 21/08/2008 16:30:12
// Result: Date5 = 21/09/2008 if Date5 is a date type attribute 
// Result: Date5 = 21/09/2008 16:30:12 if Date5 is a datetime type attribute 

Note that the resulting value corresponding to Date1 is different from the result in Date 3, so different results may be obtained when adding two months to a date (Date1 case), or adding one month twice (Date2, Date3 case). You can also subtract months from a given date (e.g. Date4).


See Also

AddMonths method
AddYr function
AddDays method