Date
The Date dimension contains shared data elements about calendar information, such as a day, month, and year.
| Data Element | Description |
|---|---|
| Date Calendar Date |
The calendar date in a standard date (MM/DD/YYYY) and time (HH:MM:SS) format. Example: 01/13/2021 12:00:00 AM Type: Attribute |
| Date Calendar Day |
A numeric value for a calendar day in a month. The number can be 1-31. Example: 13 Type: Attribute |
| Date Calendar Month |
A numeric value for a calendar month in the year. The number can be 1-12. Example: 1 Type: Attribute |
| Date Calendar Quarter |
A numeric value for a calendar quarter in a year. The number can be 1-4. Example: 1 Type: Attribute |
| Date Calendar Year |
The calendar year in YYYY format. Example: 2021 Type: Attribute |
| Date Day Name |
The name of the day of the week. Example: Wednesday Type: Attribute |
| Date Day Of Week |
The numeric value of the day of the week. The number can be 1-7. Example: 4 Type: Attribute |
| Date Day Of Week Iso |
The day of the week in ISO format. Example: 3 Type: Attribute |
| Date Day Of Year |
The numeric value of the day of the year. The number can be 1-365. Example: 13 Type: Attribute |
| Date First Day In Month |
The first day of the month in date and time format. Example: 01/01/2021 12:00:00 AM Type: Attribute |
| Date First Day In Week |
The first day of the week in date and time format, where Sunday is the first day of the week. Example: 01/10/2021 12:00:00 AM Type: Attribute |
| Date First Day In Week Iso |
The first day of the week in ISO date and time format, where Monday is the first day of the week. Example: 01/11/2021 12:00:00 AM Type: Attribute |
| Date Is Leap Year |
A flag to indicate whether the year is a leap year. Example: 0 Type: Attribute |
| Date Is Weekday |
A flag to indicate whether the day is a week day. Example: 1 Type: Attribute |
| Date Last Day In Month |
The last day in the month in date and time format. Example: 01/31/2021 12:00:00 AM Type: Attribute |
| Date Last Day In Week |
The last day in the week in date and time format, where Saturday is the last day. Example: 01/16/2021 12:00:00 AM Type: Attribute |
| Date Last Day In Week Iso |
The last day in the week in ISO date and time format, where Sunday is the last day. Example: 01/17/2021 12:00:00 AM Type: Attribute |
| Date Month Name |
The name of the month. Example: January Type: Attribute |
| Date Week Of Month |
The numeric value of the week of the month. Example: 3 Type: Attribute |
| Date Week Of Month Iso |
The numeric value of the week of the month in ISO numbering. Example: 3 Type: Attribute |
| Date Week Of Year |
The numeric value of the week of the year. Example: 3 Type: Attribute |
| Date Week Of Year Iso |
The numeric value of the week of the year in ISO numbering. Example: 3 Type: Attribute |
| Date Year Month |
The month of the year in YYYY-Mmm format. Example: 2021-Jan Type: Attribute |
| Date Year Month Day |
The calendar date in YYYY-MM-DD format. Example: 2021-11-02 Type: Attribute |
| Date Year Quarter |
The quarter of the year in YYYY-Q format. Example: 2021-1 Type: Attribute |
| Date Year Week |
The week of the year in YYYY-WW format. Example: 2021-02 Type: Attribute |