Choose Language Hide Translation Bar
Highlighted

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?
0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Re: Customized Date Formats

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

Learn it once, use it forever!

View solution in original post

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Customized Date Formats

@markbailey 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
Highlighted
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
0 Kudos
Highlighted
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
0 Kudos
Highlighted
JensRiege
Community Trekker

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?

0 Kudos
Highlighted

Re: Customized Date Formats

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

Learn it once, use it forever!

View solution in original post

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Customized Date Formats

@markbailey 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

Highlighted
JensRiege
Community Trekker

Re: Customized Date Formats

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