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