Specify the Format of the Date/Time Field in Dataset

Arcadia Enterprise provides you with options for the format of the Date/Time Field.

In the Time Modeling interface, specify the format of the Date/Time column by following these steps:

Specifying the Format of the Date/Time Column in the Dataset
Specifying the Format of the Date/Time Column in the Dataset
  1. Under Date/Time Column, click the second menu, the one that shows a format mask.

  2. From the menu, select the appropriate date format mask. Depending on your locale, the masks may have a different format. For example, the two options in this example are YYYY-MM-DD and YYY-MM-DD HH:mm:ss.

    Here, we know that the dataset does not contain the hour, minute, and second information. Therefore, we keep the default format YYYY-MM-DD.

  3. Click Save.