Customized Date Formats

[#1]

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]

Hi David,

Unfortunately JMP doesn't support custom date formatting.

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

Jeff

[#3]

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

[#4]

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

Can custom date formatting be added to JMP15?

[#5 · Accepted solution]

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

[#6 · Accepted solution]

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

[#7]

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