Skip to main content
Evaluates a specified date component in a date value and returns the last date and time in that component as a timestamp. Category: date Syntax:
Returns: DateTimeColumn Context Filtering: ✓ Yes

​
Parameters

Allowed Values for precision: year, quarter, month, week Allowed Column Types: DATETIME, DATE

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 2

​
Examples

Extracts the month component and returns the last date and time for that month.
Returns the last date and time for the year of the given date.
Last modified on March 6, 2026