cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Qin-Ilaria
Qin-Ilaria
Level I

How can I use format pattern to informat Data time --help needed

Created: Apr 24, 2023 07:02 AM  |  Last Modified: Jun 10, 2023 5:00 PM (538 views)

Hi all,

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

LogitRangeFawn5_0-1682333954391.png

 

data time format pattern.jmp
0 Kudos
1 REPLY 1
txnelson
Super User txnelson
Super User

Re: How can I use format pattern to informat Data time --help needed

Apr 24, 2023 07:42 AM (534 views)  |  Posted in reply to message from Qin-Ilaria 04-24-2023

I was able to get it to work in JMP 17, running Windows 11,  with 2 changes to your input

  1. The width needed to be 23
  2. I specified a blank between <ss> and <ampm>

txnelson_0-1682336484952.png

 

Jim
0 Kudos