JMP 10 Scripting Guide

Contents 

Convert Character Dates to Numeric Dates

Format Date/Time Values and Subset Data

Create a Formula Column

Extract Values from an Analysis into a Report

Create an Interactive Program

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 ...