Default Date/Time Format

[#1]

Hello everyone,

How can I change the default date and time format when importing from Excel?

I have the following problem:

Excel format: DD MM YYYY hh:mm:ss
After importing into JMP, it displays as: MM DD YYYY

I know how to change the format in JMP by right-clicking the column, but is there any way to change the default setting for this kind of issue?

Thank you!

[#2]

你好，

你可以通过 图片1 中的方式修改时间格式，但是里面似乎没有和你所说格式严格一致的选项。

如果你确实需要保持格式的严格一致，可以参考 图片2、3 中的方式，自己设置的话会有一点麻烦。

<DD> <MM> <YYYY> <hh24><:><mm><:><ss>

如果你会使用脚本的话，你可以先选中数据列，然后执行下面的脚本。

希望能对你有所帮助。

祝好，

by junhui zhong

Names Default To Here( 1 );

dt = Current Data Table();
col_list = dt << Get Selected Columns;
col = col_list[1];
col << Format( "Format Pattern", "<DD> <MM> <YYYY> <hh24><:><mm><:><ss>", 22, 0 )

[#3]

If you just mean the default format JMP sets to the imported columns, I think JMP might be using your operating systems format.  Using JMP > Set JMP Column Properties > About the Column Info Window > Numeric Formats 

International Formats

If you are importing or entering data that contains formatting that is specific to country standards, you might need to ensure that your number formats are interpreted correctly. On Windows, access the Control Panel’s region and language option, and select the country for which the number should be formatted. On Apple macOS, from the Apple menu, select Language & Region > Formats, and select the correct country. On later versions of Apple macOS, this option might appear under System Preferences > Language and Region.

You could create workflow for importing the data with re-format or maybe create a tag which would set the format when you use the said tag.