Free cookie consent management tool by TermsFeed

eomonth() Function

Function

eomonth( starting_date, months )

Returns the date for the last day of the month that is the number of months before or after the given starting date.

Parameters

Keyword Type Description

starting_date

Date

The starting date.

months

Integer

The number of months to offset, where negative is before starting_date and positive is after starting_date.

Returns

Date

Examples

eomonth(date(2011,12,13),-6) returns 6/30/2011

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible
Process Reports Compatible
Process Events Compatible

Feedback