Output
Generate Time Dimension produces the following output fields.
|
Field Name |
Description |
|---|---|
|
Date |
The day's date in the format <Date> <Month> <Year>, with the name of the month in the language of the server's locale setting. For example, if the server is running in an English locale, the date would read like this: 30 October 2012. |
|
DayOfMonth |
A number representing the day of the month. For example, 10 means the day is the 10th day of the month. |
|
DayOfYear |
A number representing the day of the year. For example, 304 means that the day is the 304th day of the year. |
|
IsLeapYear |
A boolean value that indicates whether the day is in a leap year, in which case the value would be true, or not, in which case the value would be false. |
|
IsWeekday |
A boolean value that indicates whether the day is a weekday (Monday through Friday), in which case the value would be true, or not, in which case the value would be false. |
|
IsWeekend |
A boolean value that indicates whether the day is a weekend day (Saturday or Sunday), in which case the value would be true, or not, in which case the value would be false. |
|
JulianDay |
A unique number for the day. The Julian day system counts January 1, 4713 BC as day 1 and numbers all subsequent days sequentially since then. For example, 2456231 means that the day is the 2,456,231st day since January 1, 4713 BC. |
|
JulianWeek |
A unique number for the day's week. The Julian system counts the first week of 4713 BC as week 1 and numbers all subsequent weeks sequentially since then. For example, 350890 means that the day is in the 350,890th week since the first week of 4713 BC. |
|
JulianYear |
A unique number for the year. The Julian system counts 4713 BC as year 1 and numbers all subsequent years sequentially since then. For example, 6725 means that the day is in the year 2012 AD. |
|
MonthName |
The name of the day's month in English. |
|
MonthNumber |
The number of the month of the year. For example, 3 means that the day is in the third month of the year. |
|
Quarter |
A number representing the quarter of the year. For example, 1 means that the day is in the first quarter of the year. |
|
WeekOfYear |
A number representing the week of the year. For example, 43 means that the day is in the 43rd week of the year. |
|
WeekdayName |
The name of the day in English. For example, Monday. |
|
WeekdayNumber |
A number representing the day of the week, with day 1 being Monday. So for example Tuesday is day 2, Wednesday is day 3, and so on. |
|
Year |
The day's year according to the Gregorian calendar. For example, 2012 means that the day is in the year 2012. |