The END function returns the last date of a time period.
This function is useful if you want to calculate maturity dates or due dates that fall on the last day of the month.
Syntax
END([Time period])
Arguments
| Argument | Data type | Description |
| Time period (optional) | Time period | The time period used to find the end date from. If you do not include an argument, END returns the last date of each period within the source module's time dimension. |
The END function returns a date value.
Additional information
The format used to display the date depends on your OS/browser settings. For example, the U.S. date format displays the month before the day (mm/dd/yyyy).
Note: If the time period is blank, the result is blank.
Excel equivalent
Examples
The example below shows END( ). No argument is used and the module is time period formatted for months.
| Jan 14 | Feb 15 | |
Period End Date
| 31/01/2014 | 28/02/2014 |
The example below shows END with the Time period argument. End Month is formatted for months and End Quarter is formatted for quarters.
| Key Dates | Expiry Dates | |
| Month Period | Feb 14 | Apr 16 |
| Quarter Period | Q2 FY14 | Q3 FY16 |
End Month
| 28/02/2014 | 30/04/2016 |
End Quarter
| 30/06/2014 | 30/09/2016 |
The final example below shows END with a hard-coded argument.
| Key Dates | Expiry Dates | |
| Month Period | Feb 14 | Apr 15 |
| Quarter Period | Q2 FY14 | Q3 FY14 |
End Date Absolute
| 31/12/2014 | 31/12/2014 |
