Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

Returns the last day of the month of a Date value. Category: date Syntax: 
EndOfMonth([date])
Returns: DateTimeColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
datecolumn|datetime✓ YesThe date from which the end of month is to be computed.
Allowed Column Types: DATETIME, DATE

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

EndOfMonth([Invoice Date])
Extract the last day of the month from the Invoice Date column. 
EndOfMonth(Date("2023-03-07"))
Returns end of month for March 2023. Result: 2023-03-31 23:59:59
Last modified on March 13, 2026