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 From the DOB column menu, click Edit column > Transform date format. In the Transform date format based on column DOB dialog, configure the following fields: 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. From the New format list, select dd/MM/yyyy (06/06/2000). Keep the default values for the rest of the options. Click OK. ResultA new column named Copy_DOB is created, and all dates are in the dd/MM/yyyy format. Copyright © Cloud Software Group, Inc. All Rights Reserved.