Table Date
Virtual table that provides period-based date calculations and date range generation for various time periods. This table enables easy creation of date ranges for weeks, months, quarters, and years.
Remarks
The Date table is a utility table that automatically generates date periods and ranges for reporting, filtering, and date-based calculations. It provides convenient access to predefined date periods without requiring manual date arithmetic. This table is commonly used in reports, charts, and analytics where data needs to be grouped or filtered by time periods. The table dynamically calculates period boundaries and provides both localized and invariant names for international applications.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
| InherentPermissions | RX |
Fields
| Name | Type | Description |
|---|---|---|
| "Period Type" | Option | The type of date period (Date, Week, Month, Quarter, or Year). |
| "Period Start" | Date | The start date of the period. |
| "Period End" | Date | The end date of the period. |
| "Period No." | Integer | The sequential number of the period within its type (e.g., week number, quarter number). |
| "Period Name" | Text[31] | The localized name of the period formatted according to the user's language and region settings. |
| "Period Invariant Name" | Text[31] | The culture-invariant name of the period that remains consistent across different locales. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |