Transforming Date Formats

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

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. Here 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.