cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Customized Date Formats

Is it possible to write one's own customized date format? I want a variant of the "date long" format in which the day of the week is abbreviated to exactly three characters (e.g. "Sat 01-Jan-2011"). I know I could script the same effect easily enough if I had to, but I also want to carry the new format though a number of graphical displays which will pick it up and use it automatically. Can it be done?
2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Customized Date Formats

Custom formats were added to JMP 14. See Help > Books > Scripting Guide. Search for "custom format."

View solution in original post

Jeff_Perkinson
Community Manager Community Manager

Re: Customized Date Formats

@Mark_Bailey is right.

 

Custom Formats are available in JMP.

 

Here's an example of the Custom Format for date as you would like it.

JMPScreenSnapz040.png

You can also add these through JSL. See the example in the Scripting Guide.

-Jeff

View solution in original post

6 REPLIES 6
Jeff_Perkinson
Community Manager Community Manager

Re: Customized Date Formats

Hi David,

Unfortunately JMP doesn't support custom date formatting.

We'll keep it in mind for future releases though.

Jeff
-Jeff
pmroz
Super User

Re: Customized Date Formats

Jeff,

Outside of JMP, we frequently use the following date format: DD-Mon-YYYY. For example 15-Dec-1987. This prevents confusion when using the MM/DD/YYYY format (e.g. 12/15/1987), because our European colleagues reverse the month and day and use DD/MM/YYYY (same date 15/12/1987).

JMP does not have this format, so I use ddMonyyyy. When presenting information to users I create a computed text column that mimics the desired format.

Can you please put in a request for the DD-Mon-YYYY format?

Thanks,
Peter
JensRiege
Level IV

Re: Customized Date Formats

I also have the same need to get date in the format "10-JAN-2020"

Can custom date formatting be added to JMP15?

Re: Customized Date Formats

Custom formats were added to JMP 14. See Help > Books > Scripting Guide. Search for "custom format."

Jeff_Perkinson
Community Manager Community Manager

Re: Customized Date Formats

@Mark_Bailey is right.

 

Custom Formats are available in JMP.

 

Here's an example of the Custom Format for date as you would like it.

JMPScreenSnapz040.png

You can also add these through JSL. See the example in the Scripting Guide.

-Jeff
JensRiege
Level IV

Re: Customized Date Formats

Thank you. That is exactly what I was looking for.