Convert Character Dates to Numeric Dates
Data might appear to be numeric in the data table. However, the column properties specify a character data type. To manipulate the data as date/time values, you must convert the column to a numeric column.
) creates a data table, converts the character column to numeric, and applies the y/m/d format by sending messages to the column (Figure 16.2
Figure 16.1 Script for Converting Character Dates to Numeric Dates
Figure 16.2 Converting Character Dates (Before and After)