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 From the VISIT column menu, click Edit column > Transform date format. In the New column name field, enter a name for the new column. Keep the default settings, and then click OK. ResultAll the dates in the VISIT column are transformed to the MM/dd/yyy format. Copyright © Cloud Software Group, Inc. All Rights Reserved.