{{tag>Function Function_List Date_And_Time}} ====== MONTH_ADD ====== ===== Description ===== Returns the date resulting from adding/subtracting the specified number of months to the specified date ===== Syntax ===== ''MONTH_ADD (date, months)'' Can be used in the condition of a [[:ref:a_f:a:find|FIND]] action. ===== Parameters ===== An expression producing date and an expression producing a number to be added or subtracted (if the number is negative) to the date ===== Returns ===== **Date**: the date moved forward by the number of months (back if the number is negative). ===== Example ===== IF MONTH_ADD (Account.OpeningDate, 4) = 07/04/2004 THEN ... ===== Related ===== [[ref:a_f:f:af:date_add|DATE_ADD]], [[ref:a_f:f:af:time_add|TIME_ADD]], [[ref:a_f:f:af:month_difference|MONTH_DIFFERENCE]]