Transforming the Date Format of a Column

Use this function to change the representation of date.

Take project 1 in the Sample-customer dataset as an example. The date values in the DOB column is in the MM/dd/yy format. To change this format to the MMM dd,yyyy format:

Procedure

Form the DOB column menu, click Edit columns > Transform date format.
In the New column name field, enter a name or accept the default value for the new column.
Select one of the following automatic guessing options. In this example, select the first option.
- Auto guess (prefer month first)
- Auto guess (prefer day first)
- Source Format
Note: The auto guess option first tries the specified month day order. But if that option does not produce a valid date, it also tries alternative options. For example, for 10/25/2012, the Auto guess (prefer day first) option still interprets it as Oct 25, 2012, the same is true for 25/10/2012.
From the New format list, select the desired target format. In this example, select MMM dd, yyyy (June 06, 2000). Click OK.
A new column Copy_DOB is created, and all the dates are in the MMM dd,yyyy(June 06,2000) format.