https://community.jmp.com/t5/Discussions/Changing-data-type-from-character-to-continuous-with-JSL/m-p/237216#M46837 <P>From the screenshot you are displaying, it appears that whatever methodology you are using to generate the TS_UTC column, that it is being generated as a character column.&nbsp; The following JSL will convert from your character column to a numeric, continuous column, with your desired display format.</P> <PRE><CODE class=" language-jsl">names default to here(1); dt=current data table(); dt:TS_UTC&lt;&lt;data type(numeric)&lt;&lt;modeling type(continuous)&lt;&lt;format("yyyy-mm-ddThh:mm:ss");</CODE></PRE> Wed, 04 Dec 2019 11:29:11 GMT txnelson 2019-12-04T11:29:11Z https://community.jmp.com/t5/Discussions/Changing-data-type-from-character-to-continuous-with-JSL/m-p/237194#M46834 <P>I have a script that gets back the time as character. The format is correct but I want&nbsp; to automate this change of data type automatically.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tsformat.jpg" style="width: 781px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/20516i2EDEBE0BD6000710/image-size/large?v=v2&amp;px=999" role="button" title="tsformat.jpg" alt="tsformat.jpg" /></span></P><P>How to do so in JSL scripting?</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 04 Dec 2019 10:38:57 GMT https://community.jmp.com/t5/Discussions/Changing-data-type-from-character-to-continuous-with-JSL/m-p/237194#M46834 FN 2019-12-04T10:38:57Z https://community.jmp.com/t5/Discussions/Changing-data-type-from-character-to-continuous-with-JSL/m-p/237216#M46837 <P>From the screenshot you are displaying, it appears that whatever methodology you are using to generate the TS_UTC column, that it is being generated as a character column.&nbsp; The following JSL will convert from your character column to a numeric, continuous column, with your desired display format.</P> <PRE><CODE class=" language-jsl">names default to here(1); dt=current data table(); dt:TS_UTC&lt;&lt;data type(numeric)&lt;&lt;modeling type(continuous)&lt;&lt;format("yyyy-mm-ddThh:mm:ss");</CODE></PRE> Wed, 04 Dec 2019 11:29:11 GMT https://community.jmp.com/t5/Discussions/Changing-data-type-from-character-to-continuous-with-JSL/m-p/237216#M46837 txnelson 2019-12-04T11:29:11Z