https://community.jmp.com/t5/Discussions/How-can-I-use-format-pattern-to-informat-Data-time-help-needed/m-p/625424#M82422 <P>I was able to get it to work in JMP 17, running Windows 11,&nbsp; with 2 changes to your input</P> <OL> <LI>The width needed to be 23</LI> <LI>I specified a blank between &lt;ss&gt; and &lt;ampm&gt;</LI> </OL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1682336484952.png" style="width: 648px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52285i004814692A928D44/image-dimensions/648x609?v=v2" width="648" height="609" role="button" title="txnelson_0-1682336484952.png" alt="txnelson_0-1682336484952.png" /></span></P> <P>&nbsp;</P> Mon, 24 Apr 2023 11:42:10 GMT txnelson 2023-04-24T11:42:10Z https://community.jmp.com/t5/Discussions/How-can-I-use-format-pattern-to-informat-Data-time-help-needed/m-p/625403#M82421 <P>Hi all,</P><P>why can't use Format Pattern to transform the data type as JMP data time? Anyone can help give tips of operation or JSL code? thanks</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LogitRangeFawn5_0-1682333954391.png" style="width: 309px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52275iB1A100273583A951/image-dimensions/309x294?v=v2" width="309" height="294" role="button" title="LogitRangeFawn5_0-1682333954391.png" alt="LogitRangeFawn5_0-1682333954391.png" /></span></P><P>&nbsp;</P> Sun, 11 Jun 2023 00:00:46 GMT https://community.jmp.com/t5/Discussions/How-can-I-use-format-pattern-to-informat-Data-time-help-needed/m-p/625403#M82421 Qin-Ilaria 2023-06-11T00:00:46Z https://community.jmp.com/t5/Discussions/How-can-I-use-format-pattern-to-informat-Data-time-help-needed/m-p/625424#M82422 <P>I was able to get it to work in JMP 17, running Windows 11,&nbsp; with 2 changes to your input</P> <OL> <LI>The width needed to be 23</LI> <LI>I specified a blank between &lt;ss&gt; and &lt;ampm&gt;</LI> </OL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1682336484952.png" style="width: 648px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52285i004814692A928D44/image-dimensions/648x609?v=v2" width="648" height="609" role="button" title="txnelson_0-1682336484952.png" alt="txnelson_0-1682336484952.png" /></span></P> <P>&nbsp;</P> Mon, 24 Apr 2023 11:42:10 GMT https://community.jmp.com/t5/Discussions/How-can-I-use-format-pattern-to-informat-Data-time-help-needed/m-p/625424#M82422 txnelson 2023-04-24T11:42:10Z