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.
Convert Dates.jsl (Figure 16.1) 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)
Format ...

Get JMP 10 Scripting Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.