Choose where you’d like to start

eomonth()

Overview

The eomonth() function takes dateTimeValue and numberOfMonths as arguments. It adds the specified number of months to the given date-time value, and returns the last date value from the resulted date-time value.

The date value (without time value) will be returned in the format specified in Application Settings.

Return Type

  • Date-Time

Syntax

<variable>=<dateTimeValue>.eomonth(<numberOfMonths>);

(OR)

<variable>=eomonth(<dateTimeValue>, <numberOfMonths>);
ParameterDescriptionData type
<variable>Variable which will contain the returned date-time value.DATE-TIME
<dateTimeValue>

The date-time value to which the specified number of months will be added, and the last date value will be returned from the resulted date-time value.

The time value is not taken into account while using this function.

A runtime error will be encountered if:

  • the date value exceeds the number of days in that month.
  • an incorrect month value is specified.
  • the hour value, or the minutes value, or the seconds value is specified in more than 2 digits.
  • the year value has more than 4 digits.

Refer this help document to learn about the supported date-time formats.

DATE-TIME
<number>

The number of months to be added to dateTimeValue.

A negative number will subtract the specified number of months from dateTimeValue.

NUMBER

Examples

currentDate = '01-Jan-2019';
newDate = currentDate.eomonth(1);      // returns '28-Feb-2019'

Get Started Now

Execute