{{tag>Function Function_List Date_And_Time}} ====== LAST_DAY_OF_MONTH ====== ===== Description ===== Calculates the date that corresponds to the last day of month of the provided date ===== Syntax ===== ''LAST_DAY_OF_MONTH (date)'' Can be used in the condition of a [[:ref:a_f:a:find|FIND]] action. ===== Parameters ===== Attribute of the Date type or date constant or calculation producing a date ===== Returns ===== **Date**: the last day of the month of the given date. ===== Example ===== IF LAST_DAY_OF_MONTH (Account.OpeningDate)=31/10/2004 THEN ... ===== Related ===== [[ref:a_f:f:af:first_day_of_month|FIRST_DAY_OF_MONTH]], [[ref:a_f:f:af:last_day_of_next_month|LAST_DAY_OF_NEXT_MONTH]], [[ref:a_f:f:af:last_day_of_prev_month|LAST_DAY_OF_PREV_MONTH]], [[ref:a_f:f:af:month_add|MONTH_ADD]]