User Community
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: 
  • Due to inclement weather, JMP support response times may be slower than usual during the week of January 26.
    To submit a request for support, please send email to support@jmp.com.
    We appreciate your patience at this time.
  • Register to see how to import and prepare Excel data on Jan. 30 from 2 to 3 p.m. ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 (1014 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 (1010 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

Recommended Articles