I have the same problem. We use the German Version of JMP. When I import a table from Microsoft SQL-Server I get a date if the datatype is datetime (well) and when I import the datatime2(7) I get only a string.
Example for datetime (Correct)
In SQL-Server:
Import in JMP:
Query result: ![TraceLevelBird5_2-1715941699567.png TraceLevelBird5_2-1715941699567.png](https://community.jmp.com/t5/image/serverpage/image-id/64346i4D92C3D3EE68066D/image-size/medium?v=v2&px=400)
Example for datetime2 (not recognized as date, only as string)
In SQL-Server:
Import in JMP:
Query result:![TraceLevelBird5_5-1715942364441.png TraceLevelBird5_5-1715942364441.png](https://community.jmp.com/t5/image/serverpage/image-id/64350i5968A8B55A50CF33/image-size/medium?v=v2&px=400)
How can I get datetime2 is date in JMP?
Thanks