Table of Contents

, ,

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

FIRST_DAY_OF_QUARTER, LAST_DAY_OF_MONTH, LAST_DAY_OF_NEXT_MONTH, LAST_DAY_OF_PREV_MONTH