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 ...