nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

lwx228

Hello, everyone!

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

Thanks!

Accepted answers

txnelson

Here is the formula for the conversion

Date DMY(
	Num( Substr( :date, 7, 2 ) ),
	Num( Substr( :date, 5, 2 ) ),
	Num( Substr( :date, 1, 4 ) ) ) + 
	60 * 60 * Num( Word( 2, :date, " :" ) ) + 
	60 * Num( Word( -1, :date, " :" ) )

Jeff_Perkinson

@txnelson's formula will work but there's a slightly simpler formula that will work also.

This one uses Informat() to convert the date and time values.

Informat( Word( 1, :Column 1 ) ) +Informat( Word( 2, :Column 1 ), "h:m" )

All comments

lwx228

The column names in the diagram should be
yyyymmdd hh:mm

txnelson

Here is the formula for the conversion

Date DMY(
	Num( Substr( :date, 7, 2 ) ),
	Num( Substr( :date, 5, 2 ) ),
	Num( Substr( :date, 1, 4 ) ) ) + 
	60 * 60 * Num( Word( 2, :date, " :" ) ) + 
	60 * Num( Word( -1, :date, " :" ) )

Jeff_Perkinson

@txnelson's formula will work but there's a slightly simpler formula that will work also.

This one uses Informat() to convert the date and time values.

Informat( Word( 1, :Column 1 ) ) +Informat( Word( 2, :Column 1 ), "h:m" )

lwx228

Thanks!
Jim Let me know the principle, Jeff_Perkinson let me learn JMP function.

lwx228

How can JMP get the text of year, month and day from the date format?
Sorry to bother you again,Thank you!

txnelson

Your question is vague. Please give an example of what the input values looks like, and what you want the output value to be...….

Jeff_Perkinson

The Format() function is used to convert a JMP date, time or datetime value to a text string.

For example:

x=informat("20000214");

show(format(x, "m/d/y"));

show(format(x, "d/m/y"));

show(format(x, "Date Long"));

show(format(x, "Monddyyyy"));

Results in this in the log:

Format(x, "m/d/y") = "02/14/2000";
Format(x, "d/m/y") = "14/02/2000";
Format(x, "Date Long") = "Monday, February 14, 2000";
Format(x, "Monddyyyy") = "Feb142000";

lwx228

That's the style,Thanks!

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

Alina199121

I have one data with one varieble that can inculde diferent types of dates.
Exmple:
17 January 2015
Or
12-6/2013
Or
20.Jan1997
Or
March 26 2001
Or
12-23-1991
They will changed in code.
So, I need to have date in YYYY-MM-DD format in my second variable.

First var is Mdfc
Second Var is Fdtc

Can you help to have the solution?
Thank you !