Dates in XMD

Specify the first day of the week for the year.

1"dates" : [
2  {
3    "alias" : "Order_Date",
4    "label" : "Order Date", 
5    "firstDayOfWeek" : -1,
6    "fiscalMonthOffset":0,
7    "fields" : {
8      "day" : "Order_Date_Day",
9      "epochDay" : "Order_Date_day_epoch",
10      "epochSecond" : "Order_Date_sec_epoch",
11      "fullField" : "Order_Date",
12      "hour" : "Order_Date_Hour",
13      "minute" : "Order_Date_Minute",
14      "month" : "Order_Date_Month",
15      "quarter" : "Order_Date_Quarter",
16      "second" : "Order_Date_Second",
17      "week" : "Order_Date_Week",
18      "year" : "Order_Date_Year"
19    }
20  },
21  {
22    "alias" : "Ship_Date",
23    "label" : "Ship Date",
24    "firstDayOfWeek" : -1,
25    "fiscalMonthOffset":0,
26    "fields" : {
27      "day" : "Ship_Date_Day",
28      "epochDay" : "Ship_Date_day_epoch",
29      "epochSecond" : "Ship_Date_sec_epoch",
30      "fullField" : "Ship_Date",
31      "hour" : "Ship_Date_Hour",
32      "minute" : "Ship_Date_Minute",
33      "month" : "Ship_Date_Month",
34      "quarter" : "Ship_Date_Quarter",
35      "second" : "Ship_Date_Second",
36      "week" : "Ship_Date_Week",
37      "year" : "Ship_Date_Year"
38    }
39  }
40],

The dates section can have the following parameters.

Parameter	Description
alias	Identifier (API name) for the dataset field used to generate the date part fields in the dataset. For example, Order_Date generates Order_Date_Month and Order_Date_Minute.
fields	Array of the date part fields, like CloseDate_Day, CloseDate_Year, and CloseDate_Hour. You must specify all date parts. If `fiscalMonthOffset` is set in the dataflow or XMD file for CSV data, you must also specify fiscal date parts, like CloseDate_Week_Fiscal. To specify a date part, use the format `<date_field_name>_<date_part>`. For example, for the week date part for the CloseDate field, enter `CloseDate_Week`.
firstDayOfWeek	(Integer) Declares the first day of the week: 0 = Sunday, 1 = Monday, and so on. –1 = the first day of the calendar year. To prevent unexpected behavior, specify the first day of the week consistently for every date field in the dataset.
fiscalMonthOffset	(Integer) The difference in the number of months between the calendar year and the fiscal year. Set this parameter to an integer between 0 and 11. Although you’re required to set this parameter, the system ignores it. The system uses only the `fiscalMonthOffset` parameter set in the dataflow or XMD file for CSV uploads.
label	Display name for the dataset field, up to 40 characters. Example: `"label": "Closing Date"`

For more information about date parts and the first day of the week, see Date Handling in Datasets.

Analytics Extended Metadata (XMD) Reference

Dates in XMD