DATESMTD
The DATESMTD function returns a table with a single column that contains the dates from the beginning of the month in the current context to the last date in the current context.
STARTOFMONTH
The STARTOFMONTH function returns the first day of the month in the current context (or the first day of the first month, if the current context includes more than one) for the specified date column.
STARTOFQUARTER
The STARTOFQUARTER function returns the first day of the quarter in the current context (or the first day of the first quarter, if the current context includes more than one) for the specified date column.
ENDOFMONTH
The ENDOFMONTH function returns the last day of the month in the current context (or the last month, if the current context includes more than one) for the specified date column.
ENDOFQUARTER
The ENDOFQUARTER function returns the last day of the quarter in the current context (or the last quarter, if the current context includes more than one) for the specified date column.
ENDOFYEAR
The ENDOFYEAR function returns the last day of the year in the current context (or the last year, if the current context includes more than one) for the specified date column.
STARTOFYEAR
The STARTOFYEAR function returns the first day of the year in the current context (or the first day of the first year, if the current context includes more than one) for the specified date column.
OPENINGBALANCEQUARTER
The OPENINGBALANCEQUARTER function evaluates an expression at the beginning of the quarter in the current context.
OPENINGBALANCEYEAR
The OPENINGBALANCEYEAR function evaluates an expression at the beginning of the year in the current context.
CLOSINGBALANCEMONTH
The CLOSINGBALANCEMONTH function evaluates an expression for the last day of the month in the current context (or for the last day of the last month, if more than one is involved).
