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: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lwx228
lwx228
Level VIII

How to convert text format Numbers to yyyymmdd hh:mm format?

Nov 30, 2018 09:35 AM (16113 views)

Hello, everyone!

How to use JSL or formula to convert the text of column 1 into the time format of column 2.

 

Thanks!

2018-11-30_22-27-38.png2018-11-30_22-27-38.png

 

0 Kudos
10 REPLIES 10
lwx228
lwx228
Level VIII

Re: How to convert text format Numbers to yyyymmdd hh:mm format?

Created: Dec 3, 2018 06:52 PM  |  Last Modified: Dec 3, 2018 3:55 PM (9355 views)  |  Posted in reply to message from Jeff_Perkinson 12-03-2018

That's the style,Thanks!

The effect is the same:
format(x, "y/m/d")  ————    format(x, "yyyyymmdd")

0 Kudos

Recommended Articles