Unknown date format

[#1]

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?

[#2]

try changing the - to /

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

[#3]

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?

[#4]

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

[#5]

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

[#6]

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

[#7]

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?

[#8 · Accepted solution]

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.