ColumnDescription
date_idUnique identifier of a date in the table
dateRepresents date in the format of DD-MM-YYYY. For example, 2018-01-01
day_of_monthStands for the day component (range between 1 to 31)
week_of_yearStands for the calendar week of the year ( range between 1 to 52)
monthStands for each month part Jan 2018
yearYear in YYYY format
quarterQuarterly 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_numberIt is the cumulative week count from beginning of a date calendar. This is of no practical use case in report or list
week_start_dateStart date of the calendar week in DD-MM-YYYY format
week_end_dateThe date in the format of DD-MM-YYYY when the calendar week end
day_of_weekDay of a week - Monday to Sunday
month_noDenotes the cumulative month count from beginning of date calendar. This is of no practical use case in report or list
month_no_of_yearDenotes the month number of a year (1 for January , 2 for February and so forth)
month_of_yearMonth of a year - January, February,..December