Date Dim Explore
This article applies to the following Customer Insights roles: Developer
Maintains date information, enabling you to “slice and dice” dates in different ways and using different formats. Includes:
- Date Dim
- Creation Date Dim
- Deactivated Date Dim
- Email Verified Date Dim
- Last Login Date Dim
- Last Updated Date Dim
Measures
- Count
Dimensions
Au Format Date
Specified date using the Australian date format: DD/MM/YYYY:
- DD, two-digit day, including a leading zero as needed.
- MM. two-digit month, including a leading zero if needed.
- YYYY, four-digit year.
Sample data:
18/10/2018
Day is Last of Month
Indicates whether the day is the last day of the month. A 1 mean that the day is the last day of the month; a 0 means that it is not. Sample data:
0
Day is Weekday
Indicates whether the specified date is a weekday (Monday through Friday). A value of 1 indicates that the date is a weekday; a value of 0 means that the date is a weekend (Saturday or Sunday). Sample data:
1
Day Name
Returns the day name (Monday, Tuesday, Wednesday, etc.) for the specified date. Sample data:
Tuesday
Full Date
Enables you to return a specified portion of a date:
- Date: Returns the full date formatted as four-digit year, two-digit month, and two-digit date (2018-10-18)
- Month: Returns the four-digit year and the two-digit month (2018-07)
- Quarter: Returns the year and quarter (2018-Q2)
- Week: Returns the week of the year (42)
- Year: Returns the year only (2018)
Sample data:
2018-01-14
Month Day Number
Day of the month for the specified date. For example, December 19 has a month day number of 19. Sample data:
18
Month Name
Name of the month (January, February, March, etc.) for the specified date. Sample data:
January
Month Number
Month number for the specified date, with 1 indicating January and 12 indicating December. Sample data:
10
Quarter Number
Indicates the quarter (1, 2, 3, or 4) for the specified date. Quarters are as follows:
- 1: January 1 through March 31
- 2: April 1 through June 30
- 3: July 1 through August 31
- 4: October 1 through December 31
Sample data:
1
Us Format Date
Specifies the date using the format MM/DD/YYYY:
- MM, two-digit month, including a leading zero as needed.
- DD, two-digit day, including a leading zero if needed.
- YYYY, four-digit year.
Sample data:
09/03/2018
Week Day Number
Number indicating the day of the week, with 1 meaning Sunday and 7 meaning Saturday. Sample data:
3
Year Day Number
Day of the year, with 1 indicating January 1 and 365 (or 366 in a leap year) indicating December 31. For example, February 1, 2018 has a year day value of 32, because that was the 32nd day in the year 2018. Sample data:
97
Year Number
Four-digit year for the specified date. For example, July 12, 2018 has the year number 2018. Sample data:
2018
Year Week Number
Week number for the specified date. Week numbers begin on the Monday of the week of January 4. For example, January 4, 2019 falls on a Friday. Therefore, for week of the year purposes, Week 1 for the year 2019 actually begins on Monday, December 31, 2018, the Monday of that week. Sample data:
51
Updated over 2 years ago