Convert CDISC ISO8601 Character Date to Numeric

[#1]

This add-in converts a CDISC ISO8601 character variable into a separate numeric date or date-time variable that can make filtering easier. For the current data table, the add-in only lists the available character variables that end in DTC, which would include all date-time fields in CDISC domains. The sample data set is not CDISC, but it allows you to get a sense of how the add-in works.

Running the above on the following table

will create a numeric version of the column

Creating a data filer on the numeric date allows you to select a range of dates.

Compare this to a filter on the character version of the date that only allows for selecting specific dates.

[jenkins_macedo]

Why the current formula option in JMP Pro has the ability to do this that usually requires creating new columns and using the appropriate formulas to generate the date or datetime value desire. The Add-in gives us an added edge to making this process simple and quick.