Transforming the Date Format

Use this function to change the representation of date.

Take project 1 in Sample-customer dataset for example. The date values in the DOB column is in the mm/dd/yy format. To change it to the mmm dd,yyyy format:

Procedure

Form the DOB column menu, click Edit columns > Transform date format.
The Transform date format based on column DOB dialog opens.
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 case, 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 as for 25/10/2012.
From the New format list, select the desired target format. In this case, 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.