How to Define Date and Time Data Types When Wrangling Data

During the data wrangling process you can change a column's data type to display dates and times in an appropriate format.

Open the Data Wrangling dialog while importing data.
In the Select Column drop-down list, choose the column you want to modify.
In the Select Function drop-down list, under the Transform Cell selections, choose Change Data Type. See Functions for Wrangling Data for more information about the various functions in this drop-down list.
In the next drop-down list, select whether to use a Number, Date, or Text format.
Enter the applicable format in Input Date Format using characters from the table below.

If your data displays 01022014 for January 2, 2014, enter a date format of MMddyyyy in Input Date Format. If your data displays 2014.01.02, enter a date format of yyyy.MM.dd. If your data displays Thu Jan 2, 14, enter a date format of EEE MMM d, yy.

All data format options in the table below are case-specific.

Date Format	Description
G	Era designator, such as AD or BC
y	Year, such as 96 or 1996
M	Month in year, such as 01, Jan, or January
w	Week number in year. The 27th week of the year appears as 27.
W	Week number in month. The second week of February appears as 2.
D	Day number in year. The 189th day of the year appears as 189.
d	Day number in month, such as 10
F	Day of week in month, such as 2
E	Day name, such as Sun or Sunday
a	AM or PM marker, to display time using a 12-hour clock
H	Hour, based on a 24-hour clock, from 0 to 23
k	Hour, based on a 24-hour clock, from 1 to 24
K	Hour in AM or PM, from 0 to 11
h	Hour in AM or PM, from 1 to 12
m	Minute
s	Second
S	Millisecond
z	Time zone, such as GMT-08:00, PST, or Pacific Standard Time
Z	Time zone using the RFC 822 four-digit time zone, such as -0800