Specifying the date/time field and the format of date/time for dataset

In the Time Modeling page, specify the Date/Time Field of the dataset using the following steps:

  1. At the top of the page, click EDIT.
  2. Under Date/Time Field, click the first drop-down list and select the name of the correct field, one that contains the date information.

    The system groups dataset fields in timestamp or other time formats at the top, under the heading Date Fields.

    In this example, the 'inspection_date' field has been selected.

  3. Under Date/Time Column, click the second drop-down list and select the appropriate date format mask.

    Depending on your location, 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. In this example, the dataset does not contain the hour, minute, and second information, so the default format YYYY-MM-DD is kept.

  4. Click SAVE.