This data object manages a comprehensive list of calendar days for the next 30 years and serves as a central reference for time-related data in the system. It contains various date formats and information used in numerous business processes and applications for accurate time recording, scheduling and reporting. The data enables uniform and consistent handling of dates in all connected systems and processes.
identification
The basic information on the data record is stored in this area.
| Property | Description |
| Date | Specification of the date in the form DD.MM.YYYY. |
| Date Number | Specification of the date in the format YYYYMMDD. |
| Date Ecma262 | Specification of the date in Ecma262 format. |
| day | Indication of how many days of the month the specified date is. |
| month | Indication of the month of the year in which the specified date falls (January=1, February=2, ...). |
| year | Year in the format YYYY. |
ISO 8601
This area contains information on the date in accordance with ISO 8061.
| Property | Description |
| Iso Year | Specification of the year according to ISO 8061. |
| Iso Month | Indication of the month in which the date lies according to ISO 8061. |
| Iso Week | Indication of the week in which the date lies according to ISO 8061. |
Details
This characteristic group contains detailed information on a calendar day. It includes specific attributes that characterize the day more precisely and can be relevant for various analyses and evaluations.
| Property | Description |
| Weekday Number | Enter the number of the day of the week (e.g. "1" for Monday). |
| Weekday | Indication of the day of the week (e.g. "Monday"). |
| Is weekend | Indicates whether the day is on a weekend. |
| Public holiday | Indicates whether the day is a public holiday in Germany. |
| Holiday | If applicable, state the name of the holiday (e.g. "Easter Sunday"). |
| Week of the month | ⚠️ This property will be removed in one of the next releases. Please do not use it anymore.
Indication of how many weeks of the month the date is in, counted from the first day of the month and from there in weeks (e.g. if the month starts on a Wednesday, the days Wednesday to Tuesday are in the first week and the next Wednesday in the second). |
| Day of the year | Indication of how many days in the year the specified date is. |
| Week of the month | Specifies the week of the month in which the date lies, counted from the first week break (e.g. "4" for the fourth week). |
| Week in the year | Indication of the week of the year in which the date falls. |
| Month Name | Enter the name of the month in which the date falls (e.g. "April"). |
| Month Short | Specify the year and month in which the date falls in the form YYYY-MM. |
| quarter | Indication of the quarter in which the date lies ("1" for the first quarter). |
| Quarter Name | Indication of the quarter in which the date lies in words ("First" for the first quarter). |
| Day End | Specification of the English ending of the tag (e.g. "st" for the 1st for "first", "nd" for the 2nd for "second" and so on). |
Related days
This group includes characteristics that relate a calendar day to other relevant days. It enables the analysis of correlations between different dates in the context of the day under consideration.
| Property | Description |
| First day of the month | Specification of the first day of the month in which the date lies in the format DD.MM.YYYY. |
| Last day of the month | Specification of the last day of the month in which the date lies in the format DD.MM.YYYY. |
| First day of the quarter | Specification of the first day of the quarter in which the date lies in the format DD.MM.YYYY (e.g. "01.04.2025" for the first day of the second quarter). |
| Last day of the quarter | Specification of the last day of the quarter in which the date lies in the format DD.MM.YYYY (e.g. "30.06.2025" for the last day of the second quarter). |
| First day of the year | Specification of the first day of the year in which the date lies in the format DD.MM.YYYY (e.g. "01.01.2025" for all days that lie in the year 2025). |
| Last day of the year | Specification of the last day of the year in which the date lies in the format DD.MM.YYYY (e.g. "31.12.2025" for all days in this year). |
| First day of the following month | Specification of the first day of the month following the month in which the date lies in the format DD.MM.YYYY. |
| First day of the following year | Specification of the first day of the year following the year in which the date lies in the format DD.MM.YYYY (e.g. "01.01.2026" for all days that lie in the year 2025). |
