{{tag>Function Function_List Date_And_Time}} ====== LAST_DAY_OF_QUARTER ====== ===== Description ===== Returns the date of the last day of the calendar quarter (31 March, 30 June, 30 September or 31 December) that the provided date falls in ===== Syntax ===== ''LAST_DAY_OF_QUARTER (date)'' ===== Parameters ===== Attribute of the Date type or date constant or calculation producing a date ===== Returns ===== **Date**: the last day of the quarter of the provided date ===== Example ===== IF LAST_DAY_OF_QUARTER (Account.OpeningDate) = 31/12/2004 THEN ... ===== Related ===== [[ref:a_f:f:af:first_day_of_quarter|FIRST_DAY_OF_QUARTER]], [[ref:a_f:f:af:last_day_of_month|LAST_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]]