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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for