Reference for dates entity
The dates category contains the date entity used to define date references in the data model.
dates
The date entity represents dates that are referenced across multiple data warehouse entities.
| Property | Description | Example |
|---|---|---|
| dateKey | Unique identifier for this date in the data warehouse. | 20160703 |
| fullDate | This date represented in full Date/Time format. | 7/3/2016 12:00:00 AM |
| dayOfWeek | Day of week | 1 |
| dayOfMonth | Day of month | 3 |
| dayOfYear | Day of year | 185 |
| weekOfYear | Week of year | 28 |
| monthOfYear | Month of the year | 7 |
| calendarQuarter | Calendar quarter | 3 |
| calendarYear | Calendar year | 2016 |
| dateKey | Unique identifier for this date in the data warehouse. | 20160703 |
| fullDate | This date represented in full Date/Time format. | 7/3/2016 12:00:00 AM |
| dayOfWeek | Day of week | 1 |
| dayOfMonth | Day of month | 3 |
| dayOfYear | Day of year | 185 |
| weekOfYear | Week of year | 28 |
| monthOfYear | Month of the year | 7 |
| calendarQuarter | Calendar quarter | 3 |
| calendarYear | Calendar year | 2016 |
Next steps
- Learn more about the Intune Data Warehouse.