Date Dimensions
Overview
The following table contains an overview of the various dimensions of date available in the datasets.
Fields
| Name | Type | Description |
|---|---|---|
Key | Integer | A unique identifier. |
Date | Datetimeoffset | Display format is yyyy-mm-dd hh:mm:ss.sssssss +hh:mm, where +hh:mm indicates the offset from UTC. |
Day | Integer | Day of the month. |
DayName | String | Name of the day. |
Week | Integer | Week number of the year. |
ISOWeek | Integer | ISO Week number of the year. |
DayOfWeek | String | 1 = Monday; 2 = Tuesday; . . . ; 6 = Saturday; 7 = Sunday. |
Month | Integer | 1 = Pending; 2 = Calculating; 4 = Calculation Error; 6 = Invoiced; 8 = Approved; 11 = Rejected; 12 = Closed; 13 = Approving; 14 = Reopening; 15 = Closing; |
MonthName | String | 1 = January; 2 = February; . . . ; 11 = November; 12 = December. |
Quarter | Integer | Quarter number of the year. |
Year | Integer | Calendar year. |
DaysOfYear | Integer | Day of the year. |