topic Re: Unknown date format in Discussions

Unknown date format

Georgios_Tsim — Fri, 10 Jan 2025 11:45:17 GMT

For some reason I get the following error:

Unknown format: d-m-y

due to the following line of code.

Once I run the code in my colleague's PC it runs properly.(We have the same version 16.2)

In addition when we compare the available formats under the "Column info" choice I get:

and he has way more choices.....

Any idea of how I should fix it?

Re: Unknown date format

Craige_Hales — Fri, 10 Jan 2025 11:53:35 GMT

try changing the - to /

edit: and make sure you are not confusing the date and time format submenus.

Re: Unknown date format

Georgios_Tsim — Fri, 10 Jan 2025 12:11:09 GMT

This is not a solution. I am not confused and I know what I have to do, so that the code compiles at my PC.

What I asked is: why my JMP does not offer the same date formats as my colleagues even though we have the same version?

Re: Unknown date format

jthi — Fri, 10 Jan 2025 12:33:39 GMT

Possibly you have different date settings on your PCs OR in JMP.

Re: Unknown date format

Georgios_Tsim — Fri, 10 Jan 2025 13:29:20 GMT

Thanks for your response. Where can I find my date settings in JMP?

Re: Unknown date format

jthi — Fri, 10 Jan 2025 13:44:01 GMT

Preferences / Windows Specific (no idea how it would be for mac)

Re: Unknown date format

Georgios_Tsim — Fri, 10 Jan 2025 14:02:10 GMT

Okay It still doesnt work!

Even though I change the settings it does not appear the format

d-m-y

Another weird thing is that I tried my JMP 14 version there I have this format that I want.....

Unbelievable!!!

Any idea why does this happen?

Re: Unknown date format

jthi — Fri, 10 Jan 2025 14:47:19 GMT

Do you both have same date and time settings on your PCs? (Also JMP14 and JMP16.2 aren't the same software, I think it was JMP16 which did change some formatting things). I don't have that formatting option either

In my opinion only way to have somewhat reliable date formatting in JMP is to use Format Pattern and I think it was added in JMP16.

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(1),
	Compress File When Saved(1),
	New Column("Column 1",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([3660681600])
	)
);

Column(dt, 1) << Format(
	"Format Pattern", "<DD><-><MM><-><YYYY>"
);

You could also contact JMP Support. They might have pretty good idea what could be going on and they might know for example extra commands you could run to check which formats JMP is using and why.