If you have a column of dates that has a numeric data type, you can change the data type to date/time. For example, suppose you have a numeric column of dates in YYYYMMDD format. In this format, the value 20150101 represents the first day of the year 2015. You want to convert the numeric column to a date/time column in MM/DD/YYYY format. There are two ways to do this: use the format column command or use the Calculator.
In the following examples, the numeric column of dates in YYYYMMDD format is in column C1 and C2 is empty.
With the format column command, you change the data type of the column first to text and then to date/time. The text to date/time conversion lets you specify the date/time format.
Using the calculator, you can convert the data in one step. The result is stored in C2.