Transforming Date Formats

Use the data transforming function to transform the formats of a date column.

To transform the dates in the VISIT column to the MM/dd/yyy format:

Procedure

  1. From the VISIT column menu, click Edit column > Transform date format.
  2. In the New column name field, enter a name for the new column.
  3. Keep the default settings, and then click OK.

Result

All the dates in the VISIT column are transformed to the MM/dd/yyy format.