Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.