Unknown date format

Georgios_Tsim

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?

jthi

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.