Modify CDD date time part data mappings

You can configure CDD data mappings for date time items so either the entire date appears in a single database column in the CDD or each date time part appears in a separate database column in the CDD. The generated data mappings include the SPLITDATE attribute of the TARGETCOLUMNTYPE tag.

  1. At the bottom of the Project Explorer, click the Data Mappings (Data mappings button icon) button.
  2. In the Project Explorer, select a data series.
  3. In the grid, right-click and item and select Modify data point date part.
  4. Select one of the following:
    • All in one column—Changes the data mapping from multiple columns to one column.
    • Split columns—Changes the data mapping from one column to a column for each date time part.
  5. Click OK.