topic Re: JMP 17 Date/Time Format option does not have y/m/d option in Discussions

JMP 17 Date/Time Format option does not have y/m/d option

tylermcafee33 — Mon, 05 May 2025 19:29:05 GMT

I recently got a new PC and downloaded JMP17. I have used JMP17 (and older versions) on my old PC for many years now. When I go to import data to JMP or run a query that loads data with a Date/Time column, JMP doesn't recognize y/m/d as a valid format, so it reports the data with a bunch of #'s. This seems to be because the format doesn't include the option to use y/m/d Instead, it has #'s in place of the forward slashes.

Any help is greatly appreciated!

Issue:

Expected:

Re: JMP 17 Date/Time Format option does not have y/m/d option

txnelson — Mon, 05 May 2025 19:40:04 GMT

Look under the Date category of formats, not the Time, and you will find the y/m/d format

Re: JMP 17 Date/Time Format option does not have y/m/d option

Craige_Hales — Tue, 06 May 2025 02:29:36 GMT

That looks odd. Try making the width larger, maybe 32 instead of 22. I don't know where the # in the format is coming from, but the ####### in the result is supposed to mean the field is too narrow. Maybe if 32 is wide enough, we'll see what it is trying to format. (Yes, 22 should be wide enough for 2025/01/01 23:59:59)