Table of Contents

, ,

LAST_DAY_OF_PREV_MONTH

Description

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

Syntax

LAST_DAY_OF_PREV_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 before the given date.

Example

IF LAST_DAY_OF_PREV_MONTH (Account.OpeningDate)=30/09/2004 THEN ... 

LAST_DAY_OF_MONTH, LAST_DAY_OF_NEXT_MONTH, FIRST_DAY_OF_PREV_MONTH, MONTH_ADD