Beginning with JMP 16, JMP offers the ability to format dates and times in an infinite number of ways.
- Paste a raw date into a new column.
- Right click and select Column Info, change the Data Type to Numeric, the Modeling Type to Continuous.
- Under Format Type, select Format Pattern, where you will change the input and output. JMP's default is to use the same format for input as for output.
- To change format for both inputs and outputs, start with the inputs.
- In the User Input Format area, deselect Use Output Format.
- Select the Format Pattern.
- In pop-up Edit Format Pattern window, scroll through options to create a string to define the formats and select OK.
- Set the same Format Pattern for the output and select Apply. You will see changed format in the data table.
Click OK to save/ close the Conlumn Info dialog window.
Resources: