DateDimension

Overview

Across the entire dataset, several fields represent dates but are not date type fields. Some examples are From and To in the LineItems table, Start and End in the Invoices table, and BillFrom in the Customers table. These are integer type foreign key fields in yyyymmdd format, that point to the DateDimension table. This table contains multiple date formats and calendar attributes to support diverse format preferences. Join the DateDimension with any other table, like Invoices or LineItems, to view the dates in any of the formats mentioned below.

Fields

Name	Type	Description
Key	Integer	Primary Key - DateDimensions Table.
Date	DateTimeOffset	Display format is yyyy-mm-dd hh:mm:ss.sssssss +hh:mm, where +hh:mm indicates the offset from UTC.
Day	Integer	Day of the month.
DayName	String	Name of the day.
Week	Integer	Week number of the year.
ISOWeek	Integer	ISO-8601 weeks run Monday–Sunday, and Week 1 contains the year’s first Thursday. It provides consistent weekly periods for billing. Standardize timestamps (e.g., to UTC) before assigning week numbers.
DayOfWeek	String	1 = Monday; 2 = Tuesday; . . . ; 6 = Saturday; 7 = Sunday.
Month	Integer	1 = January; 2 = February; . . . ; 11 = November; 12 = December.
MonthName	String	Name of the month
Quarter	Integer	Quarter number of the year.
Year	Integer	Calendar year.
DaysOfYear	Integer	Day of the year.