Any way to change date default format in Graph Builder (e.g. to m/d/y instead of y/m/d h:m:s)?

MarkJSchwab — Sat, 10 Jun 2023 20:44:50 GMT

It seems like date in Graph Builder always defaults to y/m/d h:m:s. Since I'm often looking at data that spans months or years, the X scale labels always are long strings that end in "12:00:00 AM" which creates a busy-looking axis that takes up a lot of real estate due to long diagonal strings:

X axis looks better after changing date format:

Is there a way to specify my preferred default date format? That would save me a ton of clicks because I have to reformat the dates constantly.

(What would actually be even better would be if JMP would automatically use an appropriate date scale, so if the data spans years it would use m/y, if it spans a couple months it would use m/d/y, if it spans a couple days it would use m/d/y h:m, etc. But I think that functionality probably is not there?)

Using JMP Pro 14.3.0.

Re: Any way to change date default format in Graph Builder (e.g. to m/d/y instead of y/m/d h:m:s)?

txnelson — Mon, 10 May 2021 17:26:23 GMT

You can control to default axis format in JMP 14.3 by changing the format set for your date column. If you set it to a Time format, such as m/d/y h:m:s it will use that as the default

If you change it to a different time format, it will use that as the axis values

If you change it to a Date only format, it will use that format

Finally, the handling of the date values in JMP 16 has been improved, so an alternative solution would be to upgrade to JMP 16

topic Re: Any way to change date default format in Graph Builder (e.g. to m/d/y instead of y/m/d h:m:s)? in Discussions

Any way to change date default format in Graph Builder (e.g. to m/d/y instead of y/m/d h:m:s)?

Re: Any way to change date default format in Graph Builder (e.g. to m/d/y instead of y/m/d h:m:s)?