Convert Character Date

The Convert Character Date report takes an ISO 8601 character date (which could include time), strip off the date part and add a numeric version of the variable to the data table (which can be saved with the new variable). Running this report enables you to subsequently filter your results based on a numeric variable.

This report is available under the Cols menu.

What do I need?

You must have a JMP table open and in focus. Only character date variables can be specified.

The following JMP table was generated when the DM Distribution report was run for the Nicardipine example study.

The Date/Time of Birth column (highlighted above) will be converted. Note the icon (circled, above), next to the highlighted column in the Columns pane, indicating this variable is a character (nominal) variable.

To Convert a Character Date

Make sure your JMP table is open and in focus.

Click to open the report dialog, as shown below:

Highlight the column to be converted.

Click Date Variable to specify the highlighted column.

Click Run.

Output/Results

This report adds a new column (highlighted below) containing the converted date values to the end of the JMP table.

Note: The label for the new column has “Numeric” appended to the original column label.

Compare the icon (circled, above) for the original column in the Columns pane with the (circled above) for the new column. indicating the new variable is a numeric (continuous) variable.