{{tag>Function Function_List Date_And_Time}} ====== MONTH_DIFFERENCE ====== ===== Description ===== Calculates the month difference between the two dates as an integer constant ===== Syntax ===== ''MONTH_DIFFERENCE (date1, date2)'' Can be used in the condition of a [[:ref:a_f:a:find|FIND]] action. ===== Parameters ===== Two attributes of the Date type or date constants or calculations producing a date ===== Returns ===== **Number**: the difference in months between the two dates, as an integer. ===== Example ===== IF MONTH_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 5 THEN ... ===== Related ===== [[ref:a_f:f:af:month_difference2|MONTH_DIFFERENCE2]], [[ref:a_f:f:af:day_difference|DAY_DIFFERENCE]], [[ref:a_f:f:af:week_difference|WEEK_DIFFERENCE]], [[ref:a_f:f:af:year_difference|YEAR_DIFFERENCE]]