Table of Contents

, ,

LAST_DAY_OF_MONTH

Description

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

Syntax

LAST_DAY_OF_MONTH (date)

Can be used in the condition of a FIND action.

Parameters

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

Returns

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

Example

IF LAST_DAY_OF_MONTH (Account.OpeningDate)=31/10/2004 THEN ... 

FIRST_DAY_OF_MONTH, LAST_DAY_OF_NEXT_MONTH, LAST_DAY_OF_PREV_MONTH, MONTH_ADD