Table of Contents

, ,

FIRST_DAY_OF_QUARTER

Description

Returns the date of the first day of the calendar quarter (1 January, 1 April, 1 July or 1 October) that the provided date falls in

Syntax

FIRST_DAY_OF_QUARTER (date)

Parameters

Attribute of the Date type or date constant or calculation producing a date

Returns

Date: the first day of the quarter of the provided date

Example

IF FIRST_DAY_OF_QUARTER (Account.OpeningDate) = 01/10/2004 THEN ...

LAST_DAY_OF_QUARTER, FIRST_DAY_OF_MONTH, FIRST_DAY_OF_NEXT_MONTH, FIRST_DAY_OF_PREV_MONTH