ENDOFYEAR
Returns the last date of the year in the current context for the specified column of dates.
Archive
ENDOFQUARTER
Returns the last date of the quarter in the current context for the specified column of dates.
ENDOFMONTH
Returns the last date of the month in the current context for the specified column of dates.
DATESYTD
Returns a table that contains a column of the dates for the year to date, in the current context.
DATESQTD
Returns a table that contains a column of the dates for the quarter to date, in the current context.
DATESMTD
Returns a table that contains a column of the dates for the month to date, in the current context.
DATESINPERIOD
Returns a table that contains a column of dates that begins with the start_date and continues for the specified number_of_intervals.
DATESBETWEEN
Returns a table that contains a column of dates that begins with the start_date and continues until the end_date.
DATEADD
Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.
CLOSINGBALANCEYEAR
Evaluates the expression at the last date of the year in the current context.