377399_en-US

liliconcom

Re: Custom Date Formatting - New in JMP 16

This is very helpful!

 

I was looking over the date format options and see two of the month descriptions are:

• : Abbreviated month name
• : "In-line" month name. Always three letters.

 

Tested this out and all 12 months give a three character value for both.  What is the difference between and ?

Custom Date Formatting - New in JMP 16

 

 

Beginning with JMP 16, JMP offers the ability to format dates and times in an infinite number of ways.

 

1. Paste a raw date into a new column.
2. Right click and select Column Info, change the Data Type to Numeric, the Modeling Type to Continuous.
3. 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.
4. To change format for both inputs and outputs, start with the inputs.
   1. In the User Input Format area, deselect Use Output Format.
   2. Select the Format Pattern.
   3. In pop-up Edit Format Pattern window, scroll through options to create a string to define the formats and select OK.

   

    

   

    

5. Set the same Format Pattern for the output and select Apply.  You will see changed format in the data table.
6. Select OK to save.

 

Resources

• More about how to customize Date-Time formats using Format Patterns

Data Blending and Cleanup