| title | titleSuffix | description | keywords | author | ms.author | manager | ms.date | ms.topic | ms.service | ms.subservice | ms.localizationpriority | ms.assetid | ms.reviewer | ms.suite | search.appverid | ms.custom | ms.collection | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Date - Intune Data Warehouse |
Microsoft Intune |
Reference topic for the Date category of entity collections in the Intune Data Warehouse API. |
Intune Data Warehouse |
Erikre |
erikre |
dougeby |
12/04/2023 |
reference |
microsoft-intune |
developer |
medium |
6B4BC650-62F7-4049-9DE4-CDECB579B58F |
jamiesil |
ems |
MET150 |
intune-classic |
|
The dates category contains the date entity used to define date references in the data model.
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 |
- Learn more about the Intune Data Warehouse.