Date Dimension Table
Modified on: Tue, 21 May, 2019 at 11:09 AM
Column | Description |
date_id | Unique identifier of a date in the table |
date | Represents date in the format of DD-MM-YYYY. For example, 2018-01-01 |
day_of_month | Stands for the day component (range between 1 to 31) |
week_of_year | Stands for the calendar week of the year ( range between 1 to 52) |
month | Stands for each month part Jan 2018 |
year | Year in YYYY format
|
quarter | Quarterly split of calendar year - Q1 Jan, Feb Mar; Q2 Apr, May, Jun, and so on |
quarter_no
| Denotes the cumulative quarter count from beginning of date calendar. This is of no practical use case in report or list
|
year_quarter_no
| Denotes quarter number of a year - 1, 2, 3, 4 (1 for Q1, 2 for Q2 and so forth)
|
week_number | It is the cumulative week count from beginning of a date calendar. This is of no practical use case in report or list |
week_start_date | Start date of the calendar week in DD-MM-YYYY format |
week_end_date | The date in the format of DD-MM-YYYY when the calendar week end |
day_of_week | Day of a week - Monday to Sunday |
month_no | Denotes the cumulative month count from beginning of date calendar. This is of no practical use case in report or list |
month_no_of_year | Denotes the month number of a year (1 for January , 2 for February and so forth) |
month_of_year | Month of a year - January, February,..December |
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.