topic Re: Customized Date Formats in Discussions

Customized Date Formats

Wed, 23 Feb 2011 16:09:50 GMT

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?

Re: Customized Date Formats

Jeff_Perkinson — Wed, 23 Feb 2011 18:25:22 GMT

Hi David,

Unfortunately JMP doesn't support custom date formatting.

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

Jeff

Re: Customized Date Formats

pmroz — Wed, 23 Feb 2011 20:27:03 GMT

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

Re: Customized Date Formats

JensRiege — Tue, 20 Aug 2019 17:41:53 GMT

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

Mark_Bailey — Tue, 20 Aug 2019 18:17:31 GMT

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

Re: Customized Date Formats

Jeff_Perkinson — Tue, 20 Aug 2019 21:20:55 GMT

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

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

Re: Customized Date Formats

JensRiege — Sun, 15 Sep 2019 12:55:44 GMT

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