Status | Function | Description |
|---|---|---|
Not started | CLOSINGBALANCEWEEK | Evaluates the expression at the last date of the week in the current context. |
Not started | CLOSINGBALANCEMONTH | Evaluates the expression at the last date of the month in the current context. |
Not started | CLOSINGBALANCEQUARTER | Evaluates the expression at the last date of the quarter in the current context. |
Not started | CLOSINGBALANCEYEAR | Evaluates the expression at the last date of the year in the current context. |
Not started | 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. |
Not started | DATESBETWEEN | Returns a table that contains a column of dates that begins with a specified start date and continues until a specified end date. |
Not started | DATESINPERIOD | Returns a table that contains a column of dates that begins with a specified start date and continues for the specified number and type of date intervals. |
Not started | DATESWTD | Returns a table that contains a column of the dates for the week to date, in the current context. |
Not started | DATESMTD | Returns a table that contains a column of the dates for the month to date, in the current context. |
Not started | DATESQTD | Returns a table that contains a column of the dates for the quarter to date, in the current context. |
Not started | DATESYTD | Returns a table that contains a column of the dates for the year to date, in the current context. |
Not started | ENDOFWEEK | Returns the last date of the week in the current context for the specified column of dates. |
Not started | ENDOFMONTH | Returns the last date of the month in the current context for the specified column of dates. |
Not started | ENDOFQUARTER | Returns the last date of the quarter in the current context for the specified column of dates. |
Not started | ENDOFYEAR | Returns the last date of the year in the current context for the specified column of dates. |
Not started | FIRSTDATE | Returns the first date in the current context for the specified column of dates. |
Not started | LASTDATE | Returns the last date in the current context for the specified column of dates. |
Not started | NEXTDAY | Returns a table that contains a column of all dates from the next day, based on the first date specified in the dates column in the current context. |
Not started | NEXTWEEK | Returns a table that contains a column of all dates from the next week, based on the first date in the dates column in the current context. |
Not started | NEXTMONTH | Returns a table that contains a column of all dates from the next month, based on the first date in the dates column in the current context. |
Not started | NEXTQUARTER | Returns a table that contains a column of all dates in the next quarter, based on the first date specified in the dates column, in the current context. |
Not started | NEXTYEAR | Returns a table that contains a column of all dates in the next year, based on the first date in the dates column, in the current context. |
Not started | OPENINGBALANCEWEEK | Evaluates the expression at the first date of the week in the current context. |
Not started | OPENINGBALANCEMONTH | Evaluates the expression at the first date of the month in the current context. |
Not started | OPENINGBALANCEQUARTER | Evaluates the expression at the first date of the quarter, in the current context. |
Not started | OPENINGBALANCEYEAR | Evaluates the expression at the first date of the year in the current context. |
Not started | PARALLELPERIOD | Returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time. |
Not started | PREVIOUSDAY | Returns a table that contains a column of all dates representing the day that is previous to the first date in the dates column, in the current context. |
Not started | PREVIOUSWEEK | Returns a table that contains a column of all dates representing the week that is previous to the first date in the dates column, in the current context. |
Not started | PREVIOUSMONTH | Returns a table that contains a column of all dates from the previous month, based on the first date in the dates column, in the current context. |
Not started | PREVIOUSQUARTER | Returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context. |
Not started | PREVIOUSYEAR | Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context. |
Not started | SAMEPERIODLASTYEAR | Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context. |
Not started | STARTOFWEEK | Returns the first date of the week in the current context for the specified column of dates. |
Not started | STARTOFMONTH | Returns the first date of the month in the current context for the specified column of dates. |
Not started | STARTOFQUARTER | Returns the first date of the quarter in the current context for the specified column of dates. |
Not started | STARTOFYEAR | Returns the first date of the year in the current context for the specified column of dates. |
Not started | TOTALWTD | Evaluates the value of the expression for the week to date, in the current context. |
Not started | TOTALMTD | Evaluates the value of the expression for the month to date, in the current context. |
Not started | TOTALQTD | Evaluates the value of the expression for the dates in the quarter to date, in the current context. |
Not started | TOTALYTD | Evaluates the year-to-date value of the expression in the current context. |