JMP 11 Scripting Guide

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)