Table of Contents

, ,

FIRST_DAY_OF_MONTH

Description

Calculates the date that corresponds to the first day of month of the provided date

Syntax

FIRST_DAY_OF_MONTH (date)

Parameters

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

Returns

Date: the first day of the month of the given date.

Example

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

LAST_DAY_OF_MONTH, FIRST_DAY_OF_NEXT_MONTH, FIRST_DAY_OF_PREV_MONTH, MONTH_ADD