Dates
List Dates
Columns
| Name | Type | References | Description |
| ParentReference | String | Parent reference. Only available if IncludeReferenceColumn=true. | |
| DateSK [KEY] | Integer | Date surrogate key. | |
| Date | Datetime | A specific calendar date. | |
| DayName | String | The name of a day, such as Monday, Tuesday, Wednesday, and so on. | |
| DayOfMonth | Integer | The number associated with the day within a month. | |
| DayOfWeek | Integer | The number associated with the day within a week. | |
| DayOfYear | Integer | The number associated with the day within a year. | |
| DayShortName | String | The short name assigned to a day, such as Mon, Tue, Wed, and so on. | |
| IsLastDayOfPeriod | String | Use to filter data to determine if a day finishes in different periods such as days, weeks, months, or years. | |
| Month | String | The abbreviated name of a month and year, for example, Jan 2022, Feb 2022, Mar 2022, and so on. | |
| MonthName | String | The name of a month, such as January, February, March, and so on. | |
| MonthOfYear | Integer | The number assigned to a month. For example 1, 2, and 3 corresponding to January, February, and March. | |
| MonthShortName | String | The abbreviated name of a month, such as Jan, Feb, Mar, and so on. | |
| WeekEndingDate | Datetime | The date associated with the end of a week. | |
| WeekStartingDate | Datetime | The date associated with the start of a week. | |
| Year | Integer | The year, such as 2019, 2020, 2021 and so on. | |
| YearMonth | Integer | A number corresponding to the concatenated year and month. For example, 202201, 202202, and 202203 corresponds to January, February, and March of 2022. |