Transforming Date Formats

Use the date format transforming function to transform inconsistent date formats.

This example shows how to transform the date format of the DOB column data into the dd/MM/yyyy format.

Procedure

  1. From the DOB column menu, click Edit column > Transform date format.
  2. In the "Transform date format based on column DOB" dialog, configure the following fields:
    1. Optional: In the New column name field, enter a name for the new column.
      The dafult value is Copy_DOB. In this example, the default value is used.
    2. From the New format list, select dd/MM/yyyy (06/06/2000).
    3. Keep the default values for the rest of the options. Click OK.

Result

A new column named Copy_DOB is created, and all dates are in the dd/MM/yyyy format.
  • Removing Columns
    After transforming a column with inconsistent date format, a new column is created. You can remove the original column and rename the new column.
  • Splitting a Column
    After transforming a column with inconsistent date formats, you can split it into several columns.