Selecting subsets of date/time values

For date/time attributes, you can truncate the date/time values to only include a specific subset of the date/time units.

For example, if the attribute values include both the date and a time, you can truncate the values to only include the date.

To select subsets of date/time values:

  1. In the Catalog, select a project.
  2. Select Transform.
  3. Select the column of the attribute you want to truncate.
  4. From the transform menu, select Basic > Truncate date.
    When you select a Truncate date transformation, it is immediately added to the transformation script. There is no configuration, and the change always overwrites the selected attribute.

If you are done making changes to the project data set, you can commit the changes. See Running the transformation script against a project data set.