Placeholder for date functions
Written by Bettina Schmoll
Updated at May 13th, 2025
For labeling rows and columns, as well as for displaying different date ranges, the system contains various variables that serve as placeholders for the respective date. These are listed here according to their return value.
Columns and rows can also be combined to label them.
Please note that all placeholders enclosed in square brackets [ ] must be written in capital letters. For better readability, the brackets have been omitted in this description.
The date functions return a single date
Returns the current date.
Returns the first day of the service date of the selected period.
Returns the last day of the service date of the selected period.
Returns the first day of the reference date of the selected period.
Returns the last day of the reference date of the selected period.
Returns the first day of the capture date of the selected period.
Returns the last day of the capture date of the selected period.
Returns the first day of the report date of the selected period.
Returns the last day of the report date of the selected period.
Returns the first day of Date2 of the selected period.
Returns the last day of Date2 of the selected period.
Returns the first day of Date3 of the selected period.
Returns the last day of Date3 of the selected period.
Returns the first day of Date4 of the selected period.
Returns the last day of Date4 of the selected period.
Returns the first day of Date5 of the selected period.
Returns the last day of Date5 of the selected period.
All three variables return the start date of the budget. This is always one day greater than EACTDATE.
Returns the last day of the actuals. This is always 1 day less than SBUDDATE.
Returns the first day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the last day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the first day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
Returns the first day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
The DAY functions only return the day within the month.
Returns the day of the current date.
Returns the day of the first day of the performance date of the selected period.
Returns the day of the last day of the performance date of the selected period.
Returns the day of the first day of the reference date of the selected period.
Returns the day of the last day of the reference date of the selected period.
Returns the day of the first day of the collection date of the selected period.
Returns the day of the last day of the collection date of the selected period.
Returns the day of the first day of the report date of the selected period.
Returns the day of the last day of the report date of the selected period.
Returns the day of the first day of Date2 of the selected period.
Returns the day of the last day of Date2 of the selected period.
Returns the day of the first day of Date3 of the selected period.
Returns the day of the last day of Date3 of the selected period.
Returns the day of the first day of Date4 of the selected period.
Returns the day of the last day of Date4 of the selected period.
Returns the day of the first day of Date5 of the selected period.
Returns the day of the last day of Date5 of the selected period.
All 3 variables return the day of the budget start date.
Returns the day of the last day of the actuals.
Returns the first day of the entry date for master data changes in the selected period. However, this is only active in the historization module.
Returns the last day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the first day of the report date for master data changes for the selected period. This is only active in the Historization module.
Returns the last day of the report date for master data changes for the selected period. This is only active in the Historization module.
The WEEK functions return only the week number without the calendar year. To display the calendar week, e.g., 35/2018, a combination with the corresponding year function is required.
Returns the week number of the current date.
Returns the week number of the first day of the performance date of the selected period.
Returns the week number of the last day of the performance date of the selected period.
Returns the week number of the first day of the reference date of the selected period.
Returns the week number of the last day of the reference date of the selected period.
Returns the week number of the first day of the capture date of the selected period.
Returns the week number of the last day of the capture date of the selected period.
Returns the week number of the first day of the report date of the selected period.
Returns the week number of the last day of the report date of the selected period.
Returns the week number of the first day of Date2 of the selected period.
Returns the week number of the last day of Date2 of the selected period.
Returns the week number of the first day of Date3 of the selected period.
Returns the week number of the last day of Date3 of the selected period.
Returns the week number of the first day of Date4 of the selected period.
Returns the week number of the last day of Date4 of the selected period.
Returns the week number of the first day of Date5 of the selected period.
Returns the week number of the last day of Date5 of the selected period.
All 3 variables return the week number of the budget start date.
Returns the week number of the last day of the actuals.
Returns the week number of the first day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the week number of the last day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the week number of the first day of the report date for master data changes for the selected period. This is only active in the Historization module.
Returns the week number of the last day of the report date for master data changes for the selected period. However, this is only active in the historization module.
The MONTH functions return only the month without the calendar year.
Returns the month of the current date.
Returns the month of the first day of the performance date of the selected period.
Returns the month of the last day of the performance date of the selected period.
Returns the month of the first day of the reference date of the selected period.
Returns the month of the last day of the reference date of the selected period.
Returns the month of the first day of the collection date of the selected period.
Returns the month of the last day of the capture date of the selected period.
Returns the month of the first day of the report date of the selected period.
Returns the month of the last day of the report date of the selected period.
Returns the month of the first day of Date2 of the selected period.
Returns the month of the last day of Date2 of the selected period.
Returns the month of the first day of Date3 of the selected period.
Returns the month of the last day of Date3 of the selected period.
Returns the month of the first day of Date4 of the selected period.
Returns the month of the last day of Date4 of the selected period.
Returns the month of the first day of Date5 of the selected period.
Returns the month of the last day of Date5 of the selected period.
5.18 BMONTH, SBUDMONTH or PMONTH
All 3 variables return the month of the budget start date.
Returns the month of the last day of the actuals.
Returns the month of the first day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the month of the last day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the month of the first day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
Returns the month of the last day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
The YEAR functions only return the calendar year.
Returns the year of the current date.
Returns the year of the first day of the performance date of the selected period.
Returns the year of the last day of the performance date of the selected period.
Returns the year of the first day of the reference date of the selected period.
Returns the year of the last day of the reference date of the selected period.
Returns the year of the first day of the capture date of the selected period.
Returns the year of the last day of the capture date of the selected period.
Returns the year of the first day of the report date of the selected period.
Returns the year of the last day of the report date of the selected period.
Returns the year of the first day of Date2 of the selected period.
Returns the year of the last day of Date2 of the selected period.
Returns the year of the first day of Date3 of the selected period.
Returns the year of the last day of Date3 of the selected period.
Returns the year of the first day of Date4 of the selected period.
Returns the year of the last day of Date4 of the selected period.
Returns the year of the first day of Date5 of the selected period.
Returns the year of the last day of Date5 of the selected period.
All 3 variables return the year of the budget start date.
Returns the year of the last day of the actuals.
Returns the year of the first day of the entry date for master data changes in the selected period. However, this is only active in the historization module.
Returns the year of the last day of the entry date for master data changes in the selected period. However, this is only active in the historization module.
Returns the year of the first day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
Returns the year of the last day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
7 placeholders for the day of the week
The WEEKDAY function determines the weekday of the date. To ensure the weekday is displayed correctly, a corresponding translation of the number into a meaningful value must be stored in the NAV Controlling module under Setup / Standard Labels. Otherwise, the function will not return any values.
The WEEKDAYSHORT and WEEKDAYLONG functions differ in which value from the table – weekday(short) or weekday(long) – is returned.
7.1 TWEEKDAYSHORT, TWEEKDAYLONG
Returns the day of the week (short or long) of the current date.
7.2 SWEEKDAYSHORT, SWEEKDAYLONG
Returns the day of the week (short or long) of the first day of the service date of the selected period.
7.3 EWEEKDAYSHORT, EWEEKDAYLONG
Returns the day of the week (short or long) of the last day of the service date of the selected period.
7.4 SREFWEEKDAYSHORT, SREFWEEKDAYLONG
Returns the day of the week (short or long) of the first day of the reference date of the selected period.
7.5 EREFWEEKDAYSHORT, EREFWEEKDAYLONG
Returns the day of the week (short or long) of the last day of the reference date of the selected period.
7.6 SREGWEEKDAYSHORT, SREGWEEKDAYLONG
Returns the day of the week (short or long) of the first day of the collection date of the selected period.
7.7 EREGWEEKDAYSHORT, EREGWEEKDAYLONG
Returns the day of the week (short or long) of the last day of the collection date of the selected period.
7.8 SREPWEEKDAYSHORT, SREPWEEKDAYLONG
Returns the day of the week (short or long) of the first day of the report date of the selected period.
7.9 EREPWEEKDAYSHORT, EREPWEEKDAYLONG
Returns the day of the week (short or long) of the last day of the report date of the selected period.
7.10 S2WEEKDAYSHORT, S2WEEKDAYLONG
Returns the day of the week (short or long) of the first day of Date2 of the selected period.
7.11 E2WEEKDAYSHORT, E2WEEKDAYLONG
Returns the day of the week (short or long) of the last day of Date2 of the selected period.
7.12 S3WEEKDAYSHORT, S3WEEKDAYLONG
Returns the day of the week (short or long) of the first day of Date3 of the selected period.
7.13 E3WEEKDAYSHORT, E3WEEKDAYLONG
Returns the day of the week (short or long) of the last day of Date3 of the selected period.
7.14 S4WEEKDAYSHORT, S4WEEKDAYLONG
Returns the day of the week (short or long) of the first day of Date4 of the selected period.
7.15 E4WEEKDAYSHORT, E4WEEKDAYLONG
Returns the day of the week (short or long) of the last day of Date4 of the selected period.
7.16 S5WEEKDAYSHORT, S5WEEKDAYLONG
Returns the day of the week (short or long) of the first day of date5 of the selected period.
7.17 E5WEEKDAYSHORT, E5WEEKDAYLONG
Returns the day of the week (short or long) of the last day of Date5 of the selected period.
7.18 BWEEKDAYSHORT, BWEEKDAYLONG, SBUDWEEKDAYSHORT, SBUDWEEKDAYLONG, PWEEKDAYSHORT or PWEEKDAYLONG
All 6 variables return the day of the week (short or long) of the budget start date.
7.19 EACTWEEKDAYSHORT, EACTWEEKDAYLONG
Returns the day of the week (short or long) of the last day of the actuals.
7.20 SMREGWEEKDAYSHORT, SMREGWEEKDAYLONG
Returns the weekday (short or long) of the first day of the entry date for master data changes in the selected period. However, this is only active in the historization module.
7.21 EMREGWEEKDAYSHORT, EMREGWEEKDAYLONG
Returns the weekday (short or long) of the last day of the entry date for master data changes in the selected period. However, this is only active in the historization module.
7.22 SMREPWEEKDAYSHORT, SMREPWEEKDAYLONG
Returns the weekday (short or long) of the first day of the report date for master data changes for the selected period. This is only active in the Historization module.
7.23 EMREPWEEKDAYSHORT, EMREPWEEKDAYLONG
Returns the day of the week (short or long) of the last day of the report date for master data changes for the selected period. This is only active in the Historization module.
8. Placeholder for the weekday number
The WEEKDAYNO function determines the weekday number of the date and returns this number.
Returns the weekday number of the current date.
Returns the weekday number of the first day of the performance date of the selected period.
Returns the weekday number of the last day of the performance date of the selected period.
Returns the weekday number of the first day of the reference date of the selected period.
Returns the weekday number of the last day of the reference date of the selected period.
Returns the weekday number of the first day of the collection date of the selected period.
Returns the weekday number of the last day of the collection date of the selected period.
Returns the weekday number of the first day of the report date of the selected period.
Returns the weekday number of the last day of the report date of the selected period.
Returns the weekday number of the first day of Date2 of the selected period.
Returns the weekday number of the last day of Date2 of the selected period.
Returns the weekday number of the first day of Date3 of the selected period.
Returns the weekday number of the last day of Date3 of the selected period.
Returns the weekday number of the first day of Date4 of the selected period.
Returns the weekday number of the last day of Date4 of the selected period.
Returns the weekday number of the first day of Date5 of the selected period.
Returns the weekday number of the last day of Date5 of the selected period.
8.18 BWEEKDAYNO, SBUDWEEKDAYNO or PWEEKDAYNO
All 3 variables return the weekday number of the budget start date.
Returns the weekday number of the last day of the actuals.
Returns the weekday number of the first day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the weekday number of the last day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the weekday number of the first day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
Returns the weekday number of the last day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
The YEARANDMONTH function does not display the month and year, but rather returns the number of months from January 1, 2000, to the selected date. This value can be used to determine the number of months between two points in time.
Returns the number of months since 01/01/0000 to the current date.
Returns the number of months from 01/01/0000 to the first day of the performance date of the selected period.
Returns the number of months from 01/01/0000 to the last day of the performance date of the selected period.
Returns the number of months since 01/01/0000 to the first day of the reference date of the selected period.
Returns the number of months since 01/01/0000 to the last day of the reference date of the selected period.
Returns the number of months from 01/01/0000 to the first day of the collection date of the selected period.
Returns the number of months from 01/01/0000 to the last day of the collection date of the selected period.
Returns the number of months from 01/01/0000 to the first day of the report date of the selected period.
Returns the number of months from 01/01/0000 to the last day of the report date of the selected period.
Returns the number of months since 01/01/0000 to the first day of Date2 of the selected period.
Returns the number of months since 01/01/0000 to the last day of Date2 of the selected period.
Returns the number of months since 01/01/0000 to the first day of Date3 of the selected period.
Returns the number of months since 01/01/0000 to the last day of Date3 of the selected period.
Returns the number of months since 01/01/0000 to the first day of Date4 of the selected period.
Returns the number of months since 01/01/0000 to the last day of Date4 of the selected period.
Returns the number of months since 01/01/0000 to the first day of Date5 of the selected period.
Returns the number of months since 01/01/0000 to the last day of Date5 of the selected period.
9.18 BYEARANDMONTH, SBUDYEARANDMONTH or PYEARANDMONTH
All 3 variables return the number of months since 01/01/0000 until the start date of the budget.
Returns the number of months since 01/01/0000 to the last day of the actuals.
Returns the number of months from January 1, 2000, to the first day of the entry date for master data changes for the selected period. However, this is only active in the Historization module.
Returns the number of months from January 1, 2000, to the last day of the entry date for master data changes for the selected period. However, this is only active in the historization module.
Returns the number of months from January 1, 2000, to the first day of the report date for master data changes in the selected period. However, this is only active in the Historization module.
Returns the number of months from January 1, 2000, to the last day of the report date for master data changes for the selected period. However, this is only active in the Historization module.
The DAYCOUNT function is used to determine the number of days between a start and end date specified in the filters. This allows, for example, daily average calculations.
Returns the number of days for the period of the set performance date.
Returns the number of days for the period of the set reference date.
Returns the number of days for the period of the set capture date.
Returns the number of days for the period of the set report date.
Returns the number of days for the period of the set Date2.
Returns the number of days for the period of the set date3.
Returns the number of days for the period of the set date4.
Returns the number of days for the period of the set date5.
Returns the number of days for the period of the set entry date for master data changes . However, this is only active in the historization module.
Returns the number of days for the period of the specified report date for master data changes . However, this is only active in the historization module.
The WEEKCOUNT function is used to determine the number of weeks between a start and end date specified in the filters. This allows, for example, weekly average calculations.
Returns the number of weeks for the period of the set performance date.
Returns the number of weeks for the period of the set reference date.
Returns the number of weeks for the period of the set capture date.
Returns the number of weeks for the period of the set report date.
Returns the number of weeks for the period of the set Date2.
Returns the number of weeks for the period of the set date3.
Returns the number of weeks for the period of the set date4.
Returns the number of weeks for the period of the set date5.
Returns the number of weeks for the period of the set entry date for master data changes . However, this is only active in the historization module.
Returns the number of weeks for the period of the specified report date for master data changes . However, this is only active in the historization module.
The MONTHCOUNT function is used to determine the number of months between a start and end date specified in the filters. This allows, for example, monthly average calculations.
Returns the number of months for the period of the set performance date.
Returns the number of months for the period of the set reference date.
Returns the number of months for the period of the set capture date.
Returns the number of months for the period of the set report date.
Returns the number of months for the period of the set Date2.
Returns the number of months for the period of the set date3.
Returns the number of months for the period of the set date4.
Returns the number of months for the period of the set date5.
Returns the number of months for the period of the specified entry date for master data changes . However, this is only active in the historization module.
Returns the number of months for the period of the specified report date for master data changes . However, this is only active in the historization module.