title
Date - Intune Data Warehouse
description
Reference topic for the Date category of entity collections in the Intune Data Warehouse API.
ms.date
10/30/2024
ms.topic
reference
ms.reviewer
jamiesil
ms.collection
M365-identity-device-management
Reference for dates entity
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