EOMONTH

The EOMONTH function is used to calculate the last day of the month that is a specified number of months before or after a given date.

Applicable to

Calculated Columns

Return Value

The return value of the EOMONTH is a new date representing the end of the month.

Remark

• The months argument can be positive to add months to the @StartDate, or negative to subtract months from the @StartDate.
• The months argument can be a whole number or a column reference containing a number.
• The EOMONTH function is useful for calculating future or past dates based on a given date, and it is commonly used in financial and accounting scenarios for date calculations.
• The decimal number in the month argument will be rounded to the nearest whole number.
• The EOMONTH function is useful for calculating the end of a month for various purposes, such as financial calculations or date-based analysis. It can be helpful when you need to find due dates or track monthly metrics.

Syntax

EOMONTH(<expression>, month)

Tip

You can call in the system defined date function start date and end date as @StartDate and @StartDate respectively.

EOMONTH in Calculated Columns

Parameter	Description
Expression	The start date of the period to which you want to add or subtract months.
Month	Number of months you want to add (if positive) or subtract (if negative) from the start date.

Steps to use EOMONTH in Calculated Columns

1. Write the EOMONTH function. For instance EOMONTH(<expression>, month)
2. Replace <expression> with the start period. You can also call in @StartDate function.
3. Replace month with the month value required.
4. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Suppose you want to create a column that is three months after sales date, you can use the EOMONTH function as follows

EOMONTH( DATE(2024, 2, 01),3)

The calculated column will return the value 2024-05-31.